topic Re: Couldn't sort by date in bar graph widget in Dashboard in Cortex XSOAR Discussions

Couldn't sort by date in bar graph widget in Dashboard

assubramania — Wed, 24 Jul 2024 05:46:12 GMT

We couldn't sort by date in bar graph widget in custom dashboard. We are in XSOAR 8.7.

Please assist.

Re: Couldn't sort by date in bar graph widget in Dashboard

Jawahardeen — Sun, 18 Aug 2024 10:25:27 GMT

Same here. By default, the 'bar chart' is sorted by count. There is no option to sort by date.

Re: Couldn't sort by date in bar graph widget in Dashboard

CorentinChasseguet — Tue, 27 Aug 2024 09:32:51 GMT

Again, same issue. That is rather annoying that it is not possible to sort by day, week or month.

Re: Couldn't sort by date in bar graph widget in Dashboard

DanZerkle — Thu, 03 Oct 2024 19:33:53 GMT

I found a solution to this at JSON File Widget Example • Cortex XSOAR Administrator Guide • Reader • Palo Alto Networks documentation portal. Tested under 6.13.

Create and save the widget. Group by day, week, or month.
Edit the widget, then click on "Download as JSON" from the edit screen. Close the edit screen.
Edit the JSON, to add this line to the structure:
"sort": [{ "field": "occurred", "asc": true }]
From the Widget Library, click on the + sign to add a new widget.
Select the "Upload" option from the "+" menu, and upload the modified JSON.
Remove the old widget from your dashboard.
Add the updated widget to your dashboard.

Once this is done, you can add multiple copies of the sorted widget and modify them as needed.

Here's the sample file:

{ "dataType": "incidents", "widgetType": "column", "params": { "groupBy": [ "occurred(d)", "type" ], "valuesFormat": "abbreviated", "timeFrame": "days" }, "dateRange": { "period": { "byFrom": "days", "fromValue": 7 } }, "propagationLabels": [ "all" ], "customCalculation": { "operation": "count", "fieldName": "", "expression": "" }, "name": "Change Sort Order In Column Chart - Sort by Date", "sort": [{ "field": "occurred", "asc": true }] }

Re: Couldn't sort by date in bar graph widget in Dashboard

Jawahardeen — Sun, 17 Nov 2024 12:48:21 GMT

The issue seems to be resolved in XSOAR Cloud.

Re: Couldn't sort by date in bar graph widget in Dashboard

E.Ok204121 — Fri, 26 Sep 2025 08:41:45 GMT

I can confirm that this solution still works as expected. Thanks a lot for sharing it!