Hi all,
Do you know what I am missing in this chart?
data-series-chart
conditions: Type IN (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
Looks like within the series, the values are not restricted to "Iterations" (take a look at the screenshot).
This is my tree hierarchy Iteration --> Story --> Task --> Defect
What I would like to do show is the SUM of an iteration property (Formula) called 'Developers Units Available'. Any of you know what I am missing? I tried something similar using an aggregate property for the iteration, but the result is pretty similar
Thanks in advance,
Ariel
Comments
7 comments
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
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?
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
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...
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
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.
Hey - I'm glad I could help.
Please sign in to leave a comment.