Using x-labels-start in data-series-chart with a card type

Follow

Comments

5 comments

  • Avatar
    Ian Bridson

    Chris, do you have a property on Release Patch card such as release number? If so you could do something like


    {{
      data-series-chart
        conditions: type = 'Release Patch' AND 'Release number' >'5115' AND 'Release number' <'5200'
        cumulative: false

  • Avatar
    Chris Leon

    Hi Ian,


    Thanks for the tip.  To answer your question, there is a Releases tree that has Release as a parent to Release Patch.  I tried your suggestion, and it didn't parse, but the slightly different one:


    type = 'Release Patch' AND 'Release' > 5115


    does parse.  But it seems it returns EVERYTHING.  I tried upping the limit so only a few releases would be in there, but no luck.

  • Avatar
    Ian Bridson

    Hi Chris,


    OK, I think I see that you are trying to test using the name of the release card, which i think only works in a Select Where... IN (name1,name2), and not in the chart conditions. i have a simialr chart using story /reelase relatiionships and i restrict reelase by the release property 'start date'. do you have any properties on the reelase card tha tyou can use like this, or perhaps add something?


    {{
       data-series-chart
         conditions: 'Type' = 'Story' And 'Story Status' != Open AND 'Story Status' != Deleted
         x-title: Release
         y-title: no of stories
         x-labels-conditions: Type = Release and 'Start date' >'01/07/2010'
         cumulative: false
         plot-x-offset: 90
         chart-height: 400
         chart-width: 500
         legend-max-width: 200
         chart-type: bar
         series: 
         - label: no of stories/release
           color: darkgreen
           data: SELECT 'Release', count(*)  WHERE Type = Story and 'Story Status' != Open and 'Story Status' != Deleted
         - label: no of Completed stories
           color: purple
           data: SELECT  'Release', count(*) WHERE Type = Story and 'Story Status' = 'Awaiting sign off' OR 'Story Status' = 'Accepted'
      
     }}

  • Avatar
    Chris Leon

    Ah, that did it!  I do have a 'Proposed release date' field, but I was able to use the form NUMBER > 7000 as well.


    Hopefully you won't mind one more question.  The sorting of the items in the x-axis seems to be alphabetical by card name.  Is there a way to do it by some other property, or do I need to rename all my releases?

  • Avatar
    Ian Bridson

    Chris,


    I'm afraid I just named the cards to be sorted alphabetically so i have not looked at sorting in any detail.  However looking at the macro help for charts i think you could use another property to sort by, but it would be displayed instead of the release number, which i don't think is what you want

Please sign in to leave a comment.