Unit of Measure
Hi!
I would like to add a unit to each measure (e.g. "EUR" or "pcs") which can be shown or hidden, depending on the preference - is that possible?
Thanks!
6 replies
-
Yes - use the format string to style the measure. The custom format option will let you put whatever you want into the format mask. Remember to enclose the custom test in double quotes.
-
thanks. I used e.g. currency and the setting refers to $. How can I change to €?
Also, is it possible to add an own unit like "voltage", "watt" etc.? -
Currency is the regional locale of your data. So it likely defaults to "$". To create any other unit simply use the custom format option and type it in.
To set it up for Euro's type:
"€" #,#
-
Thanks Avi, worked exactly as needed! Just a final question, I cannot select for which users this should apply, is that since I'm signed in as the Admin user?
-
This technique, via the Discover, sets it for yourself only. To set it for users (by role), you should do it through the admin in the data source manager. If its a Pyramid data model, I would set it from inside the data model designer when you create the measure.
As of the next big release, you'll be able to set the format for all roles directly from Discover as well.