Partially Fixed

Reports 2.0: Bar & Line Chart

  • 3 February 2016
  • 5 replies
  • 33 views

Userlevel 2
It would be great if we could create a report with that totals the sum of ACV a CSM is managing as well as the number of accounts they are managing, similar to the report we have in SFDC (as seen attached).

 

5 replies

Userlevel 5
Hi Megan,

You can create this graph in reports 2.0. Steps below

1. Add "ASV" and "id" fields from customer info object to Show me section
2. Add "CSM" field to By section. Report will be rendered by default in tabular format.
3. Select "Column Line" from the visualization options and you should get a report similar to what you've shown.

Please let me know if this doesn't work.

Thanks,
Sumesh 
Userlevel 7
Badge
The only piece we do not support today is having the stacked component - you can do column and line but not currently stacked column chart.
Userlevel 2
Thanks, Sumesh! The only thing that this report lacks is the breakdown of ASV by segment. We use 4 segments to categorize our ASV by size, and if I include that, I cannot view this in the column/line chart. That is why support indicated that I should log an idea. Thanks!
Userlevel 5
Makes sense, Megan! I'll add your suggestion to the roadmap for prioritisation. 
Userlevel 7
Badge
If we can expand Megan's request a bit, these combo report types are extremely useful. They could be even more useful!

Stacked or grouped columns would be great. I'd also like to add in multiple lines. My example is to show both the average activity and the standard deviation to determine significance.

As MDA enables more and more useful data, the ability to visualize that and present it in meaningful ways to CSMs is becoming equally critical. Fascinatiung insights that I can't get a CSM to see or understand aren't useful. And when I throw the CTA because the activity level is more than 3 standard deviations away from the average... being able to actually show that quickly moves us from "uh, what?" to "oh, wow!"

Reply