Hi all,
I have a survey that I’m using to collect requests for service in our group. I’d like create a Report showing how many requests we get each week. I set up the report (screenshot attached), but I noticed that weeks without any submissions are omitted.
I verified that there’s no minimum number of records required to display.
How can I get the x-axis to show every week? It’s important for us to track “slow” weeks with no requests for service.
Thanks!
Hi Elizabeth,
to solve your issue, you could:
Create a Line Chart visualization
Add a breakout using a date field (you should see an option group date by)
Select an interval for group date by (weekly)
Transpose the axis and legend values so that the dates are on the axis (to ensure that all time intervals are displayed)
Clear legend values you don't need to focus on the specific data you want to track
Hope it helps,
CM
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
