Custom Sorting of Dimension in Combo Column Chart

Hi Team,

We want to make one Column Chart, where X-axis (Dimension) have a data point like (0-3 Days, 4-6 Days, 7-9 Days, 10-16 Days & 17+ Days) and KPI will have such as PO Lines Pending & PO Pending GR Amount. But the issue is sorting not working properly, it’s sorting randomly. Is there have a way to custom sort the Dimension.

Regards,
Rakesh Paul

Hello,

you can name the intervals yourself by writing a CASE WHEN Statements in the Dimension, so you can influence the order there.
Here is an Example for creating Month intervals for the X-axis of the Chart:

CASE
WHEN MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 1 OR MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 2 OR MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 3
THEN 'here you can call your interval – e.g 1: Months 1-3'
WHEN MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 4 OR MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 5 OR MONTH("_CEL_P2P_ACTIVITIES"."EVENTTIME") = 6
THEN ‘2: Months 4-6'
ELSE '3: Months 7-12’
END

If you number the intervals as in the example, you can make sure they are in the right order.

Best regards,
Viana