When creating reports or charts in MQL I'd like to group date related fields by week number. The attached stacked bar chart was created in Excel after exporting the data from Mingle and using the WEEKNUM() function to calculate the week number. As an example, the MQL might look something like this:
conditions: (Type = 'Story' or Type = 'Defect') and Status='Done'
labels: SELECT DISTINCT Weeknum('Done Date')
- label: Dev Stories
data: SELECT Weeknum('Done Date'), COUNT(*) WHERE type='Story'
- label: SIT Defects
data: SELECT Weeknum('Done Date'), COUNT(*) WHERE type='Defect'
Work Type Balance.png
Please sign in to leave a comment.