MarioR Member

Comments

  • I was able to create the custom sort using the following formula to accomodate the date field. CASE WHEN Variable = 'Date' THEN MAX(CASE WHEN YEAR(Date) = YEAR(CURDATE()) THEN 10 WHEN YEAR(CURDATE()) - YEAR(Date) = 1 THEN 9 WHEN YEAR(CURDATE()) - YEAR(Date) = 2 THEN 8 WHEN YEAR(CURDATE()) - YEAR(Date) = 3 THEN 7 WHEN…
    in Change chart sort order based on variable value. Comment by MarioR March 2023
Default Avatar