Hi folks,
How can I sort the "Defect Reported in Sprint" by the name of the card, rather than the card number?
Here is the MQL:
table
query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect')
regards,
Mike
Code Snippet
table
query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect')
Comments
3 comments
Hi Mike
You can use ORDER BY.
{{
table
query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect') ORDER BY name
}}
Hope that helps.
- Suzie
Oh actaully I just looked closer at that... I'm not sure if that is going to work because the property value is the number and the name.
You could acheive that by creating the table differently like this:
{{
table
query: SELECT 'name', count(*), "Sum of Defect Estimate", "SUM of Actual Effort" WHERE Type = Sprint ORDER BY name
}}
This assumes that Sprints and Defects are related in a tree structure and that you can created two aggregates called "Sum of Defect Estimate" and "SUM of Actual Effort'". This will give you a list of the sprints (sorted by name) with column for count and the two aggregates.
I hope that makes sense.
- Suzie
Hi Suzie,
Here's what I get with that...
thanks,
Mike
Please sign in to leave a comment.