Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you.
LOAD
"Submission Date",
date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,
Submission Date | customer | Amount | Expected |
30/01/2022 14:10 | John Doe | 23 | Jan-22 |
01/08/2023 16:15 | John Doe | 56 | Aug-23 |
02/07/2021 08:31 | John Doe | 42 | Jul-21 |
02/03/2024 10:34 | John Doe | 87 | Mar-24 |
02/06/2024 16:19 | John Doe | 26 | Jun-24 |
Hi @Bob07 ,
you could also just use "MonthName(date#([Submission Date])"
This will give you the name of the Month as well.
Furthermore in the x-Axis definition, you need to deactivate the "continous" option. Then your dates should be all populated on one spot per each month.
Hi @Bob07 ,
you could also just use "MonthName(date#([Submission Date])"
This will give you the name of the Month as well.
Furthermore in the x-Axis definition, you need to deactivate the "continous" option. Then your dates should be all populated on one spot per each month.
Try
Date(Floor(TimeStamp#([Submission Date] 'DD/MM/YYYY hh:mm')), 'MMM-YYYY')
Thank you. It worked when I deactivated the continuous option.