Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following line chart for sales as an average - you can find the QVW file attached:
My expression for the line chart is AVG(Sales).
The dimension is a hierarchical group with year, month and date.
What I show in the line chart is an average for every year, month and date.
The thing is that I need to show the MAX and MIN values, that you can see on the right as text objects.
Do you know how could I do that?
Thank you!
add in another expression of =max(TOTAL Sales) if you want the maximum across the selected data or simply =max(Sales) if it is the maximum for each YMD.
Hi,
You may try something like below,
Max(Aggr(Sum(Sales), Year))
Min(Aggr(Sum(Sales), Year))
Hi,
just use the overal Min and Max expressions as reference lines:
hope this helps
regards
Marco
Hi,
see attachment, the values are shown in axis x.
Regards
Thanks Marco, I like your answer but is there any way to see the blue line (average) bigger in the center of the chart and the red lines (max and min) on the sides so that I could focus on the average line chart, which is the most important thing I want to show? Thank you.
Hi,
like this?
hope this helps
regards
Marco