Skip to Content
0
Former Member
Aug 01, 2014 at 01:39 PM

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

165 Views

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