Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a line chart with dimension "Period" and expression "sum({1} Sales)", and I want to show value on 2 data points, which Period of max Sales & min Sales.
Period:
LOAD * INLINE [
PeriodID, Period
1, 201301
2, 201302
3, 201303
4, 201304
5, 201305
6, 201306
7, 201307
8, 201308
9, 201309
10,201310
11,201311
12,201312
];
Sales:
LOAD * INLINE [
Period, Sales
201301, 23000
201302, 34000
201303, 45000
201304, 12900
201305, 32039
201306, 35830
201307, 39594
201308, 20958
201309, 20493
201310, 40405
201311, 30305
201312, 93533
];
I've understood your request a little different, so here is my version attached.
Check the expression attribute expression 'Show Value' by clicking on the small + next to the expression label in chart properties - expression tab.
I've understood your request a little different, so here is my version attached.
Check the expression attribute expression 'Show Value' by clicking on the small + next to the expression label in chart properties - expression tab.
Thank you Swuehl, it is just what I want. And I can not understand why you put "total" into the expression, but it is right.
You want to find the min / max Sales value across all dimension values, not limited to the current dimension. That's why you need TOTAL qualifier here.