how to configure bar chart to display top 5 amount descending on dashboard ?

[dellapancon]

as below chart ,it displays all assignment group's amount ,i just want to display top 5 every month 

[ANIL_A_S]

Hi @dellapancon ,

Depending on whether you are using a standard Report or Performance Analytics (PA), you can achieve this with these configurations:

Option 1: If using Standard Reporting

1. Open the report in Report Designer and go to the Configure tab.
2. Set the Max number of groups dropdown to 5. (Note: If '5' isn't an option, a platform admin can add it via the sys_choice table).
3. Set your sort order to your metric (Amount) Descending.

Option 2: If using a Performance Analytics (PA) Widget

1. Open the widget record (Performance Analytics > Widgets).
2. Set the Type to Breakdown.
3. In the widget form, find the Show top x field and enter 5.
4. Set Sort on to Value and Sort direction to Descending.

Hope this helps! Let me know if you need help with either setup.

[Tanushree Maiti]

Hi @dellapancon 

Refer this. though its pretty old post, still guess ,it will help you.

Configure report to show only Top 5 

[DavidW447091066]

Use a Top N filter or rank the assignment groups within each month (for example, with RANKX in Power BI), then filter the visual to show only ranks 1–5. If you let us know which reporting tool you're using, someone can provide the exact steps.

[dellapancon]

servicenow-report ,no top N filter to choose