Heatmap visualization - Day of week sorting

[SS1510]

Hello ,

I built a heatmap visualization having row as Day of week (Monday, Tuesday), I made this field as String type and also tried by making this field as Choice by giving Value as 1,2,3.. and label as Monday , Tuesday..
But the issue is the row is coming as alphabetical sorted not showing as Proper week starting from Monday .
I tried with sorting but it did not work.

Does anyone has any way to achieve this?

[Tanushree Maiti]

Hi @SS1510 

Refer this Servicenow documentation: Heatmap reports 

                                                                          Table data options for heatmap visualizations 

Optional: Configure the sort order of the applicable fields in the report (column, row, Group by, Stack by or Trend by depending on the report type).

Select the filter icon () and choose Add Sort.

1. In the Sorting Order list, choose the field you want to sort on and then choose a-z or z-a for alphabetical order or reverse alphabetical order.

   The list contains all possible fields from the report's source and fields on extended, or related, tables. The only effective values, however, are the fields chosen for the current report (column, row, Group by, Stack by, or Trend by depending on the report type).

   Note:

   On fields from dot-walked (extended) tables, you can only sort on date fields.
2. Select the sort plus icon () to configure additional sorting order conditions. (Select the sort minus icon ( ) to delete configured sorting order conditions.)
3. Select Save.

For fields of the type Choice list, sort order is not determined alphabetically based on Label, it is sorted based on the Value of the choice field. For multi-level pivot table and heatmap reports, sort order is determined by the sequence of the choices in the list.

Also check : KB1575432 What "Element order" sort option means in a data visualization