Skip to main content
Question

Change group format from date to string

  • September 15, 2020
  • 3 replies
  • 29 views
L
Level 2
In the grouping field, I am using ROUND_MONTH(EKKO.AEDAT) as legend, but in the chart, it is showing date format as grouping column . How can I change the format to YYYY_MM ?

3 replies

C
Level 0
Hi @Lingzhi, You can try formatting the PQL formula with the Formatting drop-down in the code editor: image838601 41 KB The data will then be displayed in the format YYYY:MM I hope this helps, Best, Data Science Team
L
Level 2
  • lingzhi.lingz
  • Author
  • Level 2
  • September 16, 2020
Yes, I did same and preview is ok but when back to scatter plot chart, the format changed with a long date format
P
Level 2
Hi @Lingzhi, I had a similar issue with variable format and found a way to write the date as a string in the following way: DAY(TODAY()) || '.' || MONTH(TODAY()) || '.' || YEAR(TODAY()) Hope it helps. BRS, Patrick
Community Code of ConductAccessibility statement