I have hourly output data for an entire year. I made data columns for month, week of the month, day of the month, day of the week, and hour of the day. Currently, I have a decent Picot Chart set up that as weekday and hour in the Axis Fields category, month and week in the Report Filter category, and the hourly output in the Values category. This way I have a chart that shows me hourly output for each hour for each day of a selected week of a selected month. My issue is that not all weeks contain every weekday in a month.
The first week of January 2010 only has Friday and Saturday. It only shows hourly data for days 6 and 7 in the chart when I want it have an X-axis range of days 1-7 even if 1-5 are blank.
In summary: I want each week to display all seven days even if that week of that month doesn't have data for every week day in that week of the month. How can I accomplish this?
The first week of January 2010 only has Friday and Saturday. It only shows hourly data for days 6 and 7 in the chart when I want it have an X-axis range of days 1-7 even if 1-5 are blank.
In summary: I want each week to display all seven days even if that week of that month doesn't have data for every week day in that week of the month. How can I accomplish this?