I am working on tracking customer interactions (calls, emails, etc.) day over day. In wanting a line graph for each interaction type, there are some days without any data for certain interactions.
Is there a way to track these with zeros? I understand the complexity in telling Tableau to read data that isn't there, but I am trying to compare the different interactions side by side.
I was able to fill in the gaps between where there is no data (if there are calls on 9/1 and 9/3, then it will show 0 for 9/2), but I can't get Tableau to show zeros before or after those dates.
Workbook attached.
Hi Peter -
Sorry about the formatting, I was creating sparklines with no axis labels. I added a new tab "Sparklines All" and attached here. This better illustrates the issue: A good example of this is the "Onsite Visit" row, where the line only extends for 3 days and does not plot zeros across the rest of the dates.
