Ability to format report widgets

  • 12
  • Idea
  • Updated 2 months ago
It would be great if we could format the number that goes into a report widget. This would include being able to add a dollar sign, percent sign, how many decimals are shown, etc.
Photo of Jeremy Curry

Jeremy Curry

  • 640 Points 500 badge 2x thumb

Posted 4 months ago

  • 12
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
Yes, agreed. Give me all aesthetics.
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 11,818 Points 10k badge 2x thumb
@Jeremy, We understood the context and definitely a good idea . Thanks for posting.

@Ben, I know you are strongly waiting for this feature, You have already posted this on community.

Redirecting this request to our product team. 
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
This reply was created from a merged topic originally titled Can you put a percentage (%) in a report widget?.

I have dabbled in my first MDA work and the output is two percentage fields. One is a CSM's retention rate by number of customers and the other is their retention rate by total dollars. I am excited to share these out in our CSM dashboard so team members can track their progress on team goals!

However, I am having trouble with the report viewing and subsequent dashboard configuration. By comparison, our NPS by Owner report is easy and outputs into a nice numbered Widget. This is great for viewing in the dashboard. My new fields, however, are percentages, and the Widget option is greyed out.

Does anyone know if we can put a percentage into a Widget?
If so, how?
If not, why not? 

Thank you!
Photo of Manmeet Dosanjh

Manmeet Dosanjh, Champion

  • 3,872 Points 3k badge 2x thumb
Hey Ben! 

Yeah I was able to put a percentage into a Widget. The use case for us was that CSMs wanted to track their renewal rate in Gainisight.

So, I created a new MDA table and created a rule to push renewal data from Salesforce to the new MDA object. Then I created a formula field within the MDA itself that calculated the Renewal Rate as a percentage. So in the MDA, you can see that the field is populated with percentages.

My formula was simple so maybe that is why it worked well, just taking the amount closed/available amount and setting the 'type' for the field as a percentage. This way, in the MDA the percentage was generated. 

Then I was able to create a widget report on that renewal rate field! This was probably the hardest part for me, since to use the widget feature, we have to sum the field in the 'show me' section and have nothing in the 'By' section. So, I had to make sure that the renewal data in the MDA was in a format that I was able to summarize in the report builder. 
Photo of Ben

Ben, Champion

  • 7,932 Points 5k badge 2x thumb
Another issues here that I discovered today. Widgets seem to auto-select thousands (if applicable) rather than whole units. This is a problem if you explicitly want to show whole units in a widget.
Photo of Sagan Sherlin

Sagan Sherlin, Champion

  • 3,802 Points 3k badge 2x thumb
+1 Yes please.  This would be awesome!  Then we could have all the awesome widgets!!!