i've got a problem.
I'm trying to bar chart a simply measure but i can't get any result.
I want the date on X axis and the Overall time on Y axis but for some reason it doesnt aggregate the value.
In this screenshot i get this value on a row level but it doesnt work on a bar chart.
[Date] (dimension) [Item N°] (dimension) [Cycle Time] (dimension) [Total pieces] (measure) [Overall time](measure)
Solved! Go to Solution.
it doesnt work.
this is what i'd like to do:
for each [Date]
for each [Item n°]
a sum of [Total pieces]*[Cycle time]
to obtain a total time for every item in that date.
Strangely, if i select from the table above a [Cycle time], using it like a filter, the bar chart works, but clearly it show me only the sum of the [Item n°] associated for that particular [cycle time] * [Total pieces].
the [total pieces] is a measure: (sum(xxx)+sum(yyy))
it seems that the [cycle time] is interpreted like a label instead of a number, but in the data model is formatted like a number