Skip to main content
Discovery

Aggregating in the Drill Down View in Reporting

Related products:CS Reports
  • February 10, 2017
  • 8 replies
  • 69 views
jake_smith
  • jake_smith
    jake_smith

logan_t
  • Contributor ⭐️⭐️⭐️
  • 12 replies
Hey Team!



It's come to the attention of Support that some of our Customers are looking for added functionality to the report builder. To be exact, our customers would like the ability to adjust the values and [i]aggregation on the "drill down" report shown when clicking on the data points shown in visualized reports. 



Currently, if you were to apply aggregation to a field in the "Show Me" section, this aggregation is not visible in the drill down view. Instead, you see a tabular report that shows granular data pre-aggregation. 



Perhaps the ability to have the drill down report show the same aggregated data as in the the current report pre-visualization would be helpful! even having this as an option would be greatly appreciated!



Thanks for the assistance! Take care,

Logan Thome

8 replies

karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • February 11, 2017
Could you give an example here?  What would you like to be able to see in the drill down besides the raw data? 

karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • February 11, 2017
Could you give an example here?  What would you like to be able to see in the drill down besides the raw data? 

elizabeth_adams_c593ee
Forum|alt.badge.img
Hi Karl - I have a columnar chart that aggregates transcript data on a Count by Distinct LO ID. When I click on the details, I'd like to see just the information of those unique LOs, Title, date, etc. Instead, when I click into the detail I get all of the transcript data at an individual instance level. It gives me hundreds of records when I just need tens.



Does that make sense?

Elizabeth



karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • February 13, 2017
Ok, I think I get it.  The Distinct piece is key.  How would we show other columns since he Distinct is only on the ID?

elizabeth_adams_c593ee
Forum|alt.badge.img
For our use case, the other fields we would want to include are at  the LO level so they would be the same for each Contact ID.

karl_rumelhart
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • 460 replies
  • February 14, 2017
OK. 

elise_fujimoto
  • Contributor ⭐️⭐️⭐️
  • 11 replies
  • February 24, 2017
This would be helpful for us as well!  I'd like to be able to show "Top 10" upsells per CSM in one report, and be able to just show the top 10 deal size for expansion and the top 10 ARR customers lost on one report.



Similar to the example above, our CSMs have a lot of small upsells per year, and it would be great to be able to surface the top 10 deals per CSM on a single report.



Thanks for all you do! 

Forum|alt.badge.img
  • Contributor ⭐️
  • 2 replies
  • August 10, 2022

Reviving this post, we would also benefit greatly from this functionality. We currently have filtered widget and the drilldown view does not reflect the DISTINCT COUNT. I will unfortunately have to tell my end user that they need to download the data and remove duplicates to make the data usable, so any advancement here would be appreciated. Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings