Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a question regarding units of measure. When my data is being extracted, the unit of measure is in Liters. I want to have a button that allows me to go back and forth between Liters and Barrels.
Can someone help me with this? I have a small sample data set attached.
Hi,
Please find attached file for solution. Used button actions and variables to achieve this.
Regards,
Jagan.
Hi,
one solution:
hit button to switch between expression groups
LOAD Product,
[Sales Volume (Liters)],
[Sales Volume (Liters)]/119.240471 as [Sales Volume (Barrels)]
FROM
(biff, embedded labels, table is Sheet1$);
hope this helps
regards
Marco
Hi,
You can create a field within your script for the value converted to barrels (check the real conversion factor, below is just a sample):
Sales:
Load Product,
SalesVolumeInLiter,
SalesVolumeInLiter / 20 as SalesVolumeInBarrel
from ...
Then you create an expression for each field and use that in your charts.
Hi,
Please find attached file for solution. Used button actions and variables to achieve this.
Regards,
Jagan.
With the inline loads, what happens when I update the data and I don't have the same numbers anymore, will it still work?
Hi,
Inline load is just some fixed values, if you data is changing frequently put all your values in excel file so that it is easy to update the values. You can replace Inline with Excel or from database.
For excel use Load statement, if it is from database use SELECT statment.
Regards,
Jagan.
What if I have a third unit of measure to convert to? For example, I want to be able to see it in Liters, Barrels or Gallons
HI,
Create one more button and change the conversion variable value. Thats it.
Regards,
Jagan.