How to Convert Month Number to Month Name in SAP Lumira

[Former Member]

Hi All

Please i want someone to help me out

I have an X-axis (Month) in Number like 1, 2, 3, 4, ......... 12

But How can I change these numbers to

Month Name like Jan, Feb, Mar, Apr ..... Dec

My Second question is

In a bar chat

I have two column with count as follow

BM: 15000

Refresh : 576

How can I get the ration BM/Refresh in chart

Many thanks for you help

Best Regards

Ade

[achab · Accepted solution]

Hey Ade,

First question: I do not know how to do this.

Second question: can you create a calculated measure and divide BM/Refresh ? Then use the calculated measure in the chart?

BR

Antoine

[Former Member]

No need to use the month function.

Did you create a time hierarchy with the number?

Go in the Prepare Room, click on the gear near to the month number column

And create a date/time hierarchy.

Choose a Date hierarchy Type

and associate the column with the Month field.

You will be then able to format the month easily