Skip to main content
Question

ARR SUM of distinct customers


andr_raposo
Forum|alt.badge.img+1
  • Contributor ⭐️⭐️⭐️⭐️
  • 37 replies

Hi community! 

I have what feels like a very basic question, but I can’t seem to solve it.

In one of our dashboards we have a very simple report that shows the total timeline activities and distinct customers of said activities per month

This works perfectly fine. However, I was asked if we could have another that shows the ARR of said accounts, so, the SUM of the ARR from the distinct accounts.

Is there a way to do this within the report builder? I’m guessing I would need to calculate this via rules engine and to a auxiliary table on the MDA. 

 

Any thoughts? 

 

3 replies

romihache
Forum|alt.badge.img+8
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 420 replies
  • February 14, 2024

Would be great to have the sum of a field of distinct customers!

But as you said, I can’t think of a way to achieve this outside an additional table with a lookup to Company or a dataspace, depending on the use case
 


matthew_lind
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 650 replies
  • February 16, 2024

I think @romihache has it. There’s no route to directly report on this using the Standard objects and reporting.

Data Designer would be a great route to achieve this though.


andr_raposo
Forum|alt.badge.img+1
  • Author
  • Contributor ⭐️⭐️⭐️⭐️
  • 37 replies
  • February 19, 2024

Thank you very much @romihache @matthew_lind, that’s what I went with!

Could’ve been so much easier though 🙂


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