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.
Hello all,
how can I format my colum chart based on this formula?
Page 1 / 1
@1460044484 this is a known issue and unfortunately, you have to use a workaround to make this work. in your THEN part you will have to concatenate the format you want so for Year e.g. THEN YEAR(timestamp) or for Month .. THEN YEAR(timestamp) || '-' ||MONTH(timestamp). Hope this helps.
Best
Kevin
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.