on 08-01-2014 2:39 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.