See all bars in Report group by Priority even there are no record

[Kiks]

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

[Mark Manders]

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.

[Anurag Tripathi]

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.

[AndersBGS]

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