Skip to main content
andr_raposo
Helper ⭐️
Feb 14, 2024 9:18 AM UTC
Question

ARR SUM of distinct customers

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
VIP ⭐️⭐️⭐️⭐️⭐️
Feb 14, 2024 10:18 AM UTC

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
 

Translate
Continuous improvement is better than delayed perfection
matthew_lind
VIP ⭐️⭐️⭐️⭐️⭐️
Feb 16, 2024 9:55 PM UTC

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.

Translate
Making people their best....currently disguised as a CS Ops Architect. How can I contribute to your success?
andr_raposo
Helper ⭐️
Feb 19, 2024 9:28 AM UTC

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

Could’ve been so much easier though 🙂

Translate