Skip to main content

Scatter when using Date Aggregation (Min and Max)

  • September 24, 2019
  • 3 replies
  • 44 views

chris_mudd
Forum|alt.badge.img
I was trying to help a customer with creating a report. We are trying to show the average health score over time (Min Start Date), by accounts. With the aggregation we are not able to use a scatter. This enhancement woud be to support aggregation on the date field in the MDA, and be able to apply a scatter graph to it. Ideally we would want the report to look like the below image.



3 replies

jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • May 5, 2021

Would love to be able to show this for renewals. The dates axis would be the close data. And if possible, would like to either show the amount of the renewal on the y axis and the dot would be coloured red/yellow/green based on the health score.

 

It’s possible via stacked columns but doesn’t nearly have the same effect. 


jean.nairon
Forum|alt.badge.img+4
  • Expert ⭐️
  • May 5, 2021

 @sai_ram    or @dan_ahrens - could this be changed to an idea?


dan_ahrens
Forum|alt.badge.img+2
  • Expert ⭐️⭐️⭐️
  • May 6, 2021

 @sai_ram    or @dan_ahrens - could this be changed to an idea?

It’s a good suggestion. I’ve added it to the CS Ideas category.