cancel
Showing results for 
Search instead for 
Did you mean: 

Can we convert Date ("YYYY/MM") into 'YYYY' in SAP Lumira

Former Member
0 Kudos

Hi Everyone,

Stuck at this point with a little requirement.

I have an Excel Report in which it has two columns :- "Calendar Year/Month" and "Calculated Gallons Per Day".

I have been using these columns in Attributes and Measures sections for Visualize Section in SAP Lumira.

First of all let me share the version of the SAP Lumira I am using:

Version :- 1.13.0 Build 863

The data actually comes from SAP BW and we have an Excel Sheet created for the same.

Now, my requirement is to display the Calendar Date as "YYYY" and not "YYYY/MM", so that accordingly it shows "YYYY" in the Line Chart while visualizing.

So, my question is that can we change "YYYY/MM" to "YYYY" ?

Or, do we have to create an extra column in the Excel Sheet ?

Any assistance would be appreciated.

Thanks,

Kamal Pant

Accepted Solutions (1)

Accepted Solutions (1)

TammyPowlas
Active Contributor
0 Kudos

You should be able to do this using the Data Manipulation feature

See

Also, why not update to 1.18?

Former Member
0 Kudos

Hi Tammy,

Thank You very much for your quick response.

I have quickly tested the scenario in version 1.18, however while working simultaneously in the later version, I have found the below resolution for this:

Under Prepare ---> On the Right Hand Side, we have a Manipulation Toolbar --> Select the Column for which we have to make the changes --> Now, again from under Manipulation Toolbar --> Select any values and Under Data Actions, look for "Apply To : All Cells", it should be checked.

Now, use the option "Replace" and change the values to the required Format.

Click on Apply. And it's Done.

Please let me know if I am on the correct path.

Thanks,

Kamal Pant

TammyPowlas
Active Contributor
0 Kudos

Yes, that is what I was suggesting.  I'm glad you got it owrking

Former Member
0 Kudos

Once again Tammy, thank you for your quick response. And it was just because of the hint you gave to me.

Thanks,

Kamal

Answers (0)