Hello!
I don't know how the correct terminology for what I'm asking but basically I have a crosstab query that pulls information from a table in order to make a chart. One example is that I have access pull the number of calls per week to track the weekly trend. When calculated over the span of a year, it works great and shows Sun - Saturday. But if the user filters it for say the month of august, we may not have any calls on Sunday, Tuesday and Wednesday during that month. I still want it to show those days in the chart (or query if needed) but show 0 calls. Is this possible?
I have 3 different "trend" reports:
- Calls per hour (sorted from 00 to 23)
- Calls per month (sorted from Jan - Dec)
- Calls per week
All three drop off values on the Y axis if there is none (i.e. calls per hour pulled for Jan and no calls were between the 0800 hour so it doesn't show on chart.
I attached some pictures.
Thanks!