Skip to main content
andr_raposo
Helper ⭐️
August 25, 2020
Question

Line with Totals on line chart

  • August 25, 2020
  • 3 replies
  • 113 views

Hey guys,

 

Not sure if this is a basic questions or if it is not possible.

I have a line chart visualization that shows the count of customer accounts by Region overtime. This results in a line per region being displayed.

One request that I have from our end users is to add a line with the total numer of accounts. Is this possible? I’m not seeing how. I could have it not being aggregated by the same fields the other lines have (Region in our scenario).

 

Thanks in advance guys!

3 replies

rakesh
Gainsight Employee ⭐️
Lets put your data to work!
September 4, 2020

HI @andr_raposo 

There are 2 ways to achieve that: 

  1. Have the sum of customers in a different field and add it to the report
  2. We need Window functions in reporting to calculate the sum(ARR) in the report → This is not present now in the product and is a roadmap. 
suryanarayana
Helper ⭐️
September 6, 2020

Hi Andre,
Yeah Thats possible by using Adoption Explorer.
PFB snapshot :
 

Please let me know if am wrong.

Inguva Suryanarayana
sai_ram
Expert ⭐️⭐️
September 16, 2020

@andr_raposo is your query answered? Do you need any help here? Please let us know if you need any help here.