Skip to main content
Question

Formatting based on Formular based on year, month, week, day

  • January 25, 2021
  • 1 reply
  • 7 views
.
Level 2
Hello all, 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.

1 reply

K
Level 0
  • kevin.flesc
  • Level 0
  • November 22, 2021

@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

Community Code of ConductAccessibility statement