Jahnavi, Champion
 2,448 Points
Posted 6 months ago
Sai Ram Pulluri, Official Rep
 13,270 Points
For the First part of the question, could you please share us the usecase,where you need a numeric field in Groupby.
Since its a new enhancement request, changing this to an idea post.
Jahnavi, Champion
 2,448 Points
Ben, Champion
 8,312 Points
Dan Ahrens, Official Rep
 25,952 Points
If I understand your use case correctly, you want to show the number of customers for which the value of a given metric is 100200, 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.
Jahnavi, Champion
 2,448 Points
Dan Ahrens, Official Rep
 25,952 Points
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.
Jahnavi, Champion
 2,448 Points
 562 Points
Seeing your explanation to Jahnavi, We need to find a workaround to use a formula or a field number in reports?
I have different use cases that I tried to use a formula field, for example, A Region field that is defined in a Case Formula based on states and any others.
My question is, this is a bug that Gainsight are looking for to solve or it's working as expected?
Thanks
Dan Ahrens, Official Rep
 25,920 Points
 562 Points
Hi Dan,
I'll take another example but that's pretty much the same case:
Here I would like to get all accounts and group by Billing Cycle which is a number field (but could be a formula field)
And with this, input a percentage of each type by new accounts per month.
My fields are:
Col A = Account
Col B = Billing Cycle
Col C = Contract date
So, from here I would like to query them like this:
QUERY (A: C; "Select C, B, Count (A) where C is not null Group by C, B"; 1)
Out of the Gainsight is simple to do, the job is always getting information extracted.
An alternative is to create the report directly in Salesforce that would look something like this.
Dan Ahrens, Official Rep
 25,920 Points
You can do this in Gainsight by moving the "Billing Cycle" field to the "By:" area of the report.
 562 Points
but Billing Cycle is a number field and is not allowed to do it.
My point here from the beginning is if Gainsight is looking to enable to do it with Number and Formula Fields.
Thanks for your attention.
Dan Ahrens, Official Rep
 25,920 Points
Related Categories

Reports & Dashboards
 869 Conversations
 379 Followers