Need help with a data-series-chart

Follow

Comments

7 comments

  • Avatar
    Suzie Prince

    Hey Ariel


    Do you just want to show iterations on the x axis? If this is the case, try using x-labels-conditions: type = iteration at the chart level (i.e. below x-labels-step but above series).


    You can see more information about this and other data series chart parameters that might help you here.


    Cheers Suzie

  • Avatar
    Ariel

    Hi suzie,


    I tried that before, but this is what I get the following message:


    Error in data-series-chart macro using SampleStore project: Parameters x-labels-conditions and x-labels-tree are only supported when x-labels are driven by a relationship property. Please remove these parameters if you are not charting against a relationship property.


    This is what I used:


    {{
     data-series-chart
        conditions: Type IN (Iteration)
        x-labels-conditions: Type = Iteration
        cumulative: false
        x-labels-start:
        x-labels-end:
        x-labels-step:
        series:
        - label: Series 1
          color: black
          type: line
          data: SELECT name, SUM('Developers Units Available')
          trend: true
          trend-line-width: 2
    }}


    Thoughts?

  • Avatar
    Suzie Prince

    I see. Sorry, I missed something before.


    In your data parameter at the series you are selecting against name (i.e. SELECT name, SUM('Developers Units Available')). Do you want the name of the iteration on the x axis? If you do, I would remove the conditions parameter at the chart level (i.e. conditions: Type IN (Iteration)) and change the data parameter at the series level to say "data: SELECT Iteration, SUM('Developers Units Available')".


    See how that goes....


    - Suzie

  • Avatar
    Ariel

    Yes, you are right... What I would like to Display is something like the image attached


    The data-series-chart from the image is the following:


    {{
     data-series-chart
        cumulative: false
        x-labels-start:
        x-labels-end:
        x-labels-step:
        series:
        - label: Series 1
          color: black
          type: line
          data: SELECT Iteration, COUNT(*)
          trend: true
          trend-line-width: 2
    }}


    But this is not what I want, Because the Iteration doesn´t have a property called "Iteration" (Only Stories, Tasks and Defects from the planning tree). I expected something like this working, but it doesn´t :-(


    {{
     data-series-chart
        cumulative: false
        series:
        - label: Series 1
          color: black
          type: line
          data: SELECT name, COUNT(*) WHERE Type = Iteration
          trend: true
          trend-line-width: 2
    }}


    I think it could be something related with the "name" property. But the point is that the data is not restricted by the Where clause.


    Using the Scrum template (2.3) try the following (I know this chart is not useful, but it is perfect for my example):


    {{
     data-series-chart
        cumulative: false
        series:
        - label: Series 1
          color: black
          type: line
          data: SELECT name, COUNT(*) WHERE Type = Release
          trend: true
          trend-line-width: 2
    }}


    Thanks for your patiente...

  • Avatar
    Suzie Prince

    Ok, it took me a while but I see what you mean now. 'Developers Units Available' is an Iteration property and you want to show this against Iterations on the x-axis but because "name" is applicable to all cards and you are unable to restrict the x axis to cards of type Iteration you can not get the data series chart you want. I think, for the data series, this is impossible because you can't specify x-labels-conditions when plotting against name at the moment. I will capture this requirement.


    In the meantime, as the stack chart works slightly differently I believe that the following should get you the chart, or pretty close to the chart, that you want.


    {{
      stack-bar-chart
        conditions:
        labels: SELECT DISTINCT name where type = Iteration
        cumulative: false
        series:
        - label: Series 1
          color: green
          type: line
          data: SELECT name, sum('Developers Units Available')
          combine: total
    }}


    Please try this out and let me know how it goes.


    - Suzie

  • Avatar
    Ariel

    Suzie,


    you are great. Thanks for your help... for the moment that works perfect. This is what I did:


    Units available is a formula property, All others are aggregates within the iteration


    {{
      stack-bar-chart
        conditions:
        labels: SELECT DISTINCT name where type = Iteration
        cumulative: false
        x-title: Iteration
        y-title: Total Story Points
        chart-height: 500
        chart-width: 800
        plot-height: 370
        plot-width: 630
        series:
        - label: Units Available
          color: black
          type: line
          data: SELECT name, sum('Developers Units Available')
          combine: total
        - label: Planning Estimate
          color: yellow
          type: line
          data: SELECT name, SUM('Total Planning Estimate')
          combine: total
        - label: Development Estimate
          color: blue
          type: line
          data: SELECT name, SUM('Total Iteration Development Estimate')
          combine: total
        - label: Actual Effort
          color: green
          type: area
          data: SELECT name, SUM('Total Iteration Actual Effort')
          combine: total
        - label: Remaining Effort
          color: red
          type: area
          data: SELECT name, SUM('Total Iteration Effort Remaining')
          combine: total
    }}


    We are working on iteration 3 now and the red area is the remaining effort.


    Many thanks,


    Ariel.

  • Avatar
    Suzie Prince

    Hey - I'm glad I could help.

Please sign in to leave a comment.