Set Analysis Values

[bobbydave]

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

[rubenmarin · Accepted solution]

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

[bobbydave]

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