0

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

null
    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    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.

    • Angela_Music
    • 3 yrs ago
    • Reported - view

    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.? 

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    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:

    "€" #,#
    • Angela_Music
    • 3 yrs ago
    • Reported - view

    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? 

      • Yakov_Shaul
      • 3 yrs ago
      • Reported - view

      Angela Musić 

      Changin it from where you did only apply to you.
      As an admin, you can set it at the data source level per role.
      See image,
       Hope this helps,
      Kind Regards,
      Yakov.

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    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.

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 6Replies
  • 40Views
  • 3 Following