Benchmark reporting
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
Answers
-
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
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
0 -
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)
0 -
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.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
ideally im looking for a way to have the comparison in the same card instead of 2 cards side by side.
0 -
@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.
0 -
@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
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 708 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive