I'm trying to create a glideslope line where the expected results should be for a given time period. For instance, I have to reduce the number of backlogged files from 250 to 0 in 25 days. Therefore, I would need a trend line that decreases 10 units per day. In Excel, I would have charted this series as a line graph with the actual as a bar graph. Can something similar be created in Tableau? I've attached a picture of what I'm trying to do.
Thanks,
Glen
You'll need data somewhere that represents "Days that haven't happened yet" so that Tableau has a position to draw the projected line. This could be a date table of ascending days. There needs to be an outer join to this table and then a filter down to the relevant date window.
The following was done in Tableau with a parameter called "Start Value" set to 250.
The "Projected" calc is:
[Start Value]-(([Start Value]/size())* (index()-1))
This will create a line that traverses the available dates (where data exists) and increments downward at a rate of 250 divided by # of total days in window.
I tried to avoid including a workbook and just giving you as much detail as possible in the post response because there's just wonky stuff I created to make dummy sales data fit your scenario.
