Distribution of Close Reasons

0

Please login or register to vote for this query.

(click on this box to dismiss)

Summary of the number of questions closed by the close reason type.

Tridion

Q&A for Tridion developers and administrators

SELECT
    year( CreationDate ) as year,
    month( CreationDate ) as month,
    datepart( weekday, CreationDate ) as weekday,
    'All' AS 'Close Reason',
    '' AS CloseReasonId,
    SUM(1) AS Count
    FROM Posts 
    GROUP BY 
    year( CreationDate ) ,
    month( CreationDate ) ,
    datepart( weekday, CreationDate )

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results