Group by using numeric and calculated fields in reports

  • 3
  • Question
  • Updated 1 week ago
  • Answered
Photo of Jahnavi

Jahnavi, Champion

  • 1,234 Points 1k badge 2x thumb

Posted 3 weeks ago

  • 3
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 7,878 Points 5k badge 2x thumb
Hi Jahnavi, For the second part of the question are you referring to Formula fields in Reporting, here is the similar ask.

For the First part of the question, could you please share us the use-case,where you need a numeric field in Groupby.

Since its a new enhancement request, changing this to an idea post.
Photo of Jahnavi

Jahnavi, Champion

  • 1,234 Points 1k badge 2x thumb
I was looking at  a use case to count number of customers that fall in the range of 100-200 for metric x
Photo of Ben

Ben, Champion

  • 5,772 Points 5k badge 2x thumb
Right, this would be similar to "bucketed fields" in standard SFDC reporting. You can define a range of values to bucket accounts into and then compare that against a different value on the y axis. SF DC reporting is gross (non lightening/wave), so it would be nice if this was doable in Gainsight.
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 20,026 Points 20k badge 2x thumb
Hi Jahnavi, 

If I understand your use case correctly, you want to show the number of customers for which the value of a given metric is 100-200, right?

You can do this by setting the account name field in the report as an aggregation (count distinct) and in your filters, apply these two with an and condition linking them: "metric > 99" and "metric < 201".

This should give you a number of customers where that condition is met. 
Photo of Jahnavi

Jahnavi, Champion

  • 1,234 Points 1k badge 2x thumb
Thanks Dan, I guess this would work for a widget but not a bar chart right?
Photo of Dan Ahrens

Dan Ahrens, Gainster (employee)

  • 20,026 Points 20k badge 2x thumb
You could show this data using a bar chart visualization if you add a field to the "By" section to give you more than one numerical value to report on. 

So, for example you could apply the same logic: setting the account name field in the report as an aggregation (count distinct) and in your filters, apply these two with an and condition linking them: "metric > 99" and "metric < 201". And add a field like "Region" to the "By" area, for example.