See all bars in Report group by Priority even there are no record
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 03:39 AM
Hello all,
I would like to ask if there is a possibility with reports to show all bars (Priority 1 to 5) even there is no record so the value would be 0. Report is group by Priority. See below I have just one Case record with Priority 4 and I would like to see all bars Priority 1 to 5.
Thanks
- Labels:
-
Analytics and Reports
-
report
-
Reporting
-
Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 04:00 AM
No, that is not possible. You are making a selection of all records, grouped by the priority and the reports shows the available ones with that value. You can't report on something that isn't there. What you could do is to create a dashboard and put 5 single scores on top and the bar chart below that. If no P2's are available, the single score will show '0' and the bar chart will show you everything for the priorities you do have.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 04:08 AM - edited 07-11-2024 04:09 AM
How would that even work? IT wont show a group with 0 records. This just groups the data that is present.
You cant build that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-12-2024 04:03 AM
Hi @Kiks ,
Only possible through Performance Analytics - As mentioned both by @Anurag Tripathi and @Mark Manders , not really possible through the report designer.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/