-
1. Re: How to display high, low and average (sort of like a stock chart)
Alex Kerin Oct 31, 2012 10:08 AM (in response to Ratna Sarkar)Multiple reference lines set to "per pane" would work I would guess
-
2. Re: How to display high, low and average (sort of like a stock chart)
Alex Kerin Oct 31, 2012 10:13 AM (in response to Alex Kerin)See attached. I created two calculations for max and min and put them on the level of detail so that I could use them in the ref lines. There is only a filter on sales because the max values were so large you couldn't see the min.
-
refs.twbx.zip 1.1 MB
-
-
3. Re: How to display high, low and average (sort of like a stock chart)
Ratna Sarkar Oct 31, 2012 11:42 AM (in response to Alex Kerin)Alex, This is helpful, definitely is in the right direction. I also have my averages in the Rows shelf, and my max and min in the Level of Detail shelf. All this does for me is that my tool tip now displays average, min and max when I hover over any point in the chart (and each point is just the average). I think I am missing this whole "ref line" business -- how do I say "take this measure and plot it as a ref line". That would solve my problem. Thanks a lot.