Hi,
I'm hoping this might be something simple I'm just missing. Does anyone know how to show future days using 'Order Days Prior to Opening' rather than just skipping from 16 to 0 days?
Ideally would want to replicate the below from excel
Thanks,Thomas
I've been meaning to ask about setting regular intervals in the x axis
There is a way to accomplish this, but there isn't a feature/function to show regular intervals or all values in the dimensional data regardless of whether they have data against them.
Let's say we're looking at a Production Season as that line curve. We might have a dashboard filter for Season and Production Season that this widget respects.
Within the widget I would disable the dashboard filter for Production Season, and edit the formula to RSUM ( SUM ( [Value] ) , [Production Season] ) ) and limit the formula to the desired production season. This will open up the set of Weeks from Opening to allow for display of all weeks within the set for the selected Season on the dashboard. Alternatively, you could include ALL([Season]) if need be to open the set further. Then add another value to get all those additional weeks to actually display in the widget. I would do a simple [Total Ticket Count]/[Total Ticket Count] and set the color to white so that it's not really visible in the widget, and rename it to just a period ("."), again to limit it's visibility in the widget's output. Or you could multiply that by -1 and set the min Y-axis value to 0 to completely hide the line from the chart area.
This isn't as flexible as having something that will respect a dashboard filter on Production Season, for switching from production to production. Instead, the formula will have to be edited for such a change. However, the output is better aligned with your goals.
Best,Chris