Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a time varying area chart with two dimensions and an expression. The first dimention is time. Now I need a reference line which
should run along the graph with variation to the first dimension.
Thanks in advance,
Dhoulath
Hi Dhoulath,
may you post an example with a little data u want plot?
I can try to make a graph as tou want..
C u,
Stefano.
Hi Stefano,
Please find the sample data.
Thanks in advance,
Dhoulath
Hi Dhoulath,
I had very similar situation in the past and I was struggling to get the reference line for changing numbers. I mean if the reference line represents a static value across your Dimensions then it is very simple. You can add the same by going to Presentation Tab > Reference Lines. However, in your case you need the reference lines ([HEAD COUNT]) to change based on the Time Dimension.
I am attaching a solution which I have used in the past. It is not 100% solution you are looking for but the it delivers the results. I have used two charts and overlayed on each other. And used the transperancy and other visual properties to depict as one chart. Most important thing to remember is to lock the position of the chart. You can do the same by accessing Chart Properties > Layout > Allow Move/Size (Uncheck the option).
Also, I am not sure the reason why you have used variable in the Aggr() function. My understanding is that you have used it to capture the Dimension Group Field Name. If that's the reason then you don't need a variable (ofcourse, which is additional overhead for calculation)... you can rather use the Dimension Group name within double quotes - "PERIOD" in your example.
I hope this helps!
Cheers - DV
i have been writing the same solution...
I'd add that to fix max and min of 1 graph on the max and min of the other.
C u,
Stefano.
HI DV/ Stefano,
Thanks for the reply. I too tried the same. Still it would be helpful, if I try to manage in the same chart.
Regards,
Dhoulath
Dhoulath - I am afraid that I am hitting the brick wall in this situation. You might need to seek help from other users.
Stefano - Any idea? BTW - Nice snap
Cheers - DV