how can I format my colum chart based on this formula?
CASE
WHEN '<%= unit %>' IN( 'YEAR') THEN '%Y'
WHEN '<%= unit %>' IN( 'MONTH') THEN '%Y-%m'
WHEN '<%= unit %>' IN( 'WEEK') THEN '%Y-%m'
WHEN '<%= unit %>' IN( 'DAY') THEN '%Y-%m-%d'
END
The formula doesnt work in the format space.
image1321124 6.54 KB
Thank you in advance.