|
Creating a Custom Sort Order
For this sample data:
|
Month |
Weekday |
Date |
MonthNo |
WeekdayNo |
|
January |
Monday |
01/01/2021 |
1.00 |
1.00 |
|
February |
Tuesday |
|
2.00 |
2.00 |
|
March |
Wednesday |
|
3. 00 |
3.00 |
|
April |
Thursday |
|
4. 00 |
4.00 |
|
May |
Friday |
|
5. 00 |
5.00 |
|
June |
Saturday |
|
6. 00 |
6.00 |
|
July |
Sunday |
|
7. 00 |
7.00 |
|
August |
Monday |
|
8. 00 |
1.00 |
|
September |
Tuesday |
|
9. 00 |
2.00 |
|
October |
Wednesday |
|
10. 00 |
3.00 |
|
November |
Thursday |
|
11. 00 |
4.00 |
|
December |
Friday |
|
12. 00 |
5.00 |
When used in a visualization or filters, will be displayed as:
On the Columns pane in the Edit Data Table layout, you can create the custom sort order of the dimensions or text columns of the selected data source. Consequently, this allows the dimensions to be displayed in a visualization and filter in the correct or desired order.
Steps:
1. Click the Columns button.
The Columns pane is displayed.
2. Enter the order of the values (separated by a comma) of the dimensions or text columns under the Custom Sort Order section.
|
Title |
Custom Sort Order |
|
Month |
January,February,March,April,May |
|
Weekday |
Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday |
3. Click 
. Once saved,
a notification displays.
Using the data with custom sort order, the visualization and filters will now be displayed as:
