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.
Question
Formatting based on Formular based on year, month, week, day
Hello all,
how can I format my colum chart based on this formula?
@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.