Benchmark reporting

Eteach_PaulM

I have a lot of data about my customers use of our products and i am looking to create a report that compares there account to the anonymised full customer base. Whats the best way to do this?

To add a small challenge, i will be later using these reports in dashboards that will be embedded on our portal with Serverside filtering and domo everywhere

open to suggestions

ColemenWilson

I've done something like this before. You'll need to display the two different data sources side by side on a dashboard or app. You'll need to use PDP https://domo-support.domo.com/s/article/360042934614?language=en_US on one dataset (their account data) but not on the anonymized data. Then just create the visuals you want and then duplicate them all for the full customer base and swap out the data sources.

Eteach_PaulM

PDP wont work for me as the customers access the reports through embedded dashboard with Serverside filters. they are not licensed users so i cannot apply the access (unless i missing something on PDP)

GrantSmith

You can apply programatic filters on your embed to filter your data to only the clients data you're interested in assuming you know which client is logged in and have the filter information.

https://developer.domo.com/portal/1yafxad1u8azv-programmatic-filtering

Eteach_PaulM

ideally im looking for a way to have the comparison in the same card instead of 2 cards side by side.

bmueller_FORJ

@Eteach_PaulM - did you happen to figure out how to do this? I'm attempting to do something similar and curious if you found a solution.

Eteach_PaulM

@bmueller_FORJ the best i got was had my View, duplicate the view and anonymise the columns that need to be, then join the 2 views and use that as a comparison dataset for cards. seems to work although does mean a rather large View