Skip to main content
Question

Custom Sorting of Dimension in Combo Column Chart

  • June 18, 2019
  • 1 reply
  • 9 views
R
Level 2
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

V
Level 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: 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


Community Code of Conduct