-
1. Re: Making Certain Trend Values appear below the Axis on a Stacked Bar Chart
Shinichiro MurakamiNov 21, 2016 4:59 PM (in response to Ryan Barker)
1 of 1 people found this helpfulYou are very close to accomplish your needs.
Change the formula to
IF attr([TRENDS]) = "True Drop" OR attr([TRENDS]) = "MoM Dropped" THEN -1 * COUNTD(ID)
ELSE COUNTD(ID)
END
Because the measures are aggregated, you also need to aggregate dimensions.
Thanks,
Shin
-
2. Re: Making Certain Trend Values appear below the Axis on a Stacked Bar Chart
Ryan Barker Nov 22, 2016 1:10 PM (in response to Shinichiro Murakami)Thank you, Shin! Your explanation makes perfect sense.
Question: I have seen the ATTR() function floating around in a couple instances now. How does it apply aggregation? Is it similar to an oracle STATS_MODE function?
-
3. Re: Making Certain Trend Values appear below the Axis on a Stacked Bar Chart
Shinichiro MurakamiNov 22, 2016 4:11 PM (in response to Ryan Barker)
I have no idea about Oracle.
Just in general, under IF statement, in case yes/no judgment is based on line item basis, you don't need to use atrr() .
But the yes/no judgment is based on aggregated value, dimension also needs to be aggregated to that level with attr().
Thanks,
Shin