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

[assubramania]

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

Please assist.

[Jawahardeen]

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

[CorentinChasseguet]

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

[DanZerkle]

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

1. Create and save the widget.  Group by day, week, or month.
2. Edit the widget, then click on "Download as JSON" from the edit screen.  Close the edit screen.
3. Edit the JSON, to add this line to the structure:  
   

     "sort": [{ "field": "occurred", "asc": true }]​

4. From the Widget Library, click on the + sign to add a new widget.
5. Select the "Upload" option from the "+" menu, and upload the modified JSON.
6. Remove the old widget from your dashboard.
7. 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 }]
  }