Benchmark reporting

Eteach_PaulM
Eteach_PaulM Member
in Charting

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

Tagged:

Answers

  • ColemenWilson
    ColemenWilson Coach

    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.

    If I solved your problem, please select "yes" above

  • Eteach_PaulM
    Eteach_PaulM Member

    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
    GrantSmith Coach

    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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Eteach_PaulM
    Eteach_PaulM Member

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

  • bmueller_FORJ
    bmueller_FORJ Member

    @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
    Eteach_PaulM Member
    edited September 27

    @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

Categories