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, its sorting randomly. Is there have a way to custom sort the Dimension.
Regards,
Rakesh Paul
Page 1 / 1
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:
If you number the intervals as in the example, you can make sure they are in the right order.
Best regards,
Viana
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.