Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

Different numerical formatting depending on value

Answers

  • MzdravkovMzdravkov BulgariaSYS_ADMIN IMG42
    Hi Brittany,

    I don't think the described is supported - Calculated and Mapped Measurements have 1 specific Metric Type set (Percentage, Number or Currency), which determines their behavior in widgets and it is not dynamic.

    In case you are implementing this in a Rich Text/Custom widget, you could use a Calculated Dimension with formula:

    if ([Campaign_Primary_KPI]=="CPA")
    {
      return '$';
    }
    else if ([Campaign_Primary_KPI]=="ROAS")
    {
      return ' ';
    else
    {
      return '%';
    }

    By querying it you can append the symbol immediately after your measurement in the HTML, but it would not help in tables/charts etc.

    Regards,
    Martin
Sign In or Register to comment.