Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a value that is broken down in to 3 categories X, Y and Z. There are another of groups that will have the same categories.
I am creating a stacked bar chart and it should add the Values for each grouping. Right now, I am just concentrating on getting one group (Other) working with the correct values for Breakdown.
The value that appears that appear are totally different to what should appear.
I should be getting something like (from an excel sheet)
Group | Breakdown | Value |
---|---|---|
Other | X | 74,000 |
Other | Y | 0 |
Other | Z | 11,000 |
but instead, I am getting
Group | Breakdown | Value |
---|---|---|
Other | X | 962,000 |
Other | Y | 26,000 |
Other | Z | 143,000 |
My set analysis is:
sum({<Breakdown={'*X*', '*Y*', '*Z*'}, Grouping={'OTHER'}, Year={'2014'}, Month={'Jan'}>} Value)
Any chance someone knows what is wrong with this?
Help appreciated. Thanks
Hi, I'm not sure to understand...If you make a comparison of one month in selected (or max) year with the same month last year, the dimension should be only the month, and you can use these excpression:
Current Year: sum({<Year={$(=Max(Year))}>} [Metric Value])
Previous Year: sum({<Year={$(=Max(Year)-1)}>} [Metric Value])
About the decimal you can set, in 'Number' tab, the integer type
This is more or less what I am looking for.
I am comparing Jan 2014 and Jan 2015 and there will be data for Feb 2015 in time.
The same data for the second graph; it was just broken down into segments.
Thanks