-
1. Re: Hover Over State to see State Trend Versus Overall
Dan SanchezJun 17, 2016 7:57 AM (in response to David Stachon)
Hi David!
We should be able to accomplish this using an LOD calc. I attached a revised copy of your workbook, hopefully I didn't misunderstand the desired end result
To start with, I removed the Action dimension you had on Columns for the Trend worksheet. Next, I created a custom date, [Order Date (Month / Year)] because we will need to use that date value in the LOD calc. Next, I used this formula for the LOD:
{ fixed [Order Date (Month / Year)] :
AVG({ fixed [Order Date (Month / Year)], [State] :
AVG([Profit]) }) }
For the Trend worksheet, I placed the above LOD calc onto Rows and made the view a Dual Axis and also synchronized the axes. I then made some color formatting changes to make the individual state avg and the overall US avg contrast each other a bit for ease of viewing. The end result gives us something like this when hovering over a state:
Hope this helps! Let me know if you were hoping for something different though
Thanks David!
-
State Trend Example_REVISED.twbx 438.8 KB
-
-
2. Re: Hover Over State to see State Trend Versus Overall
David Stachon Jun 17, 2016 11:09 AM (in response to Dan Sanchez)Oh, that's really cool! thank you.
LOD calculations...
...definitely need to spend more time with them, and this is a great start.