How to sort tables by name rather than card #?

Follow

Comments

3 comments

  • Avatar
    Suzie Prince

    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

  • Avatar
    Suzie Prince

    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

  • Avatar
    Michael Green

    Hi Suzie,


       Here's what I get with that... 


     


    thanks,


    Mike


     


Please sign in to leave a comment.