If you are using version 7, right click on your date field on the view and select Show Missing Values.
If this does not resolve the issue, would you be able to post the workbook (twbx file)?
Tracy, it did worked, even it is a text field. Thanks!
I have attached a workbook with sample agent call data. I am trying to show each day of the month for each agent and then the overall pool of agents, hence the duplicate data source.
When I filter the view to show a single agent (ex: Agent 3) this filters the view down to March 2-9, leaving out March 1. When I filter the view to show Agent 1, the view includes March 1-9.
I have clicked on the DAY dimension and checked "Show Missing Values", but the view will still not show 0 or blank for agents with no calls on a specific day, like Agent 3.
How can I correct this to make it I show 0 or blank on the days when an agent has no issues worked?
ISAgents.twbx 12.1 KB