How to convert Month no. into month name

Hemant_rangdal · January 4, 2024, 3:46pm

here I need to convert Month No. 1 - 12 into Month Name Jan - Dec

Asem · January 4, 2024, 3:54pm

Hi,

You can create a calcualted field to represent the month name. If your current Month field (MonthID) is an integer:
ifelse(MonthID = 1, ‘January’, MonthID = 2, ‘February’, …‘December’).

Use this new field in your graph.

Thanks,
Asem.

Hemant_rangdal · January 5, 2024, 6:05am

but the Month ID is an calculated field

Vaibhav_Patidar · January 5, 2024, 11:12am

Hi @Hemant_rangdal
You can use calculated field also in this case like below:

You can then replace your “Month ID” field with “Month Name” calculated field, It will look like below:

Thanks

Hemant_rangdal · January 5, 2024, 1:24pm

Thanks You Vaibhav, it worked.!.