PDP on Columns?
I saw in the idea section this post: https://dojo.domo.com/discussion/41767/dataset-pdp-for-columns
But comments are turned off.
I have a dataset that is powering tons of cards. Users have access to different cards depending on the Dashboard I gave them access to. Are you telling me I have to create a different dataset if I want to block the "revenue" column from Users X, Y, and Z from seeing this data? So now I have to have two datasets for the same cards?
Answers
-
I believe the solution to this is to append your data. For example if you had two groups, one that could see revenue and one that couldn't, you would just append your data to itself once, and zero out the revenue values in the appended data. You would also have an additional column that would distinguish which is which and then create your PDP on that additional column. This would keep everything as one dataset as you could just do the append at the very end of your ETL.
Hope that makes sense.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
welp, I am confused.
I wanted to know if I can do PDP on a single column. It sounded like you said I cannot? But, the 2nd to last sentence you said I would "...create your PDP on that additional column" ?
0 -
@Canioagain sorry I wasn't clear. You are applying PDP based on values in column, which will hide that entire row. I was suggesting creating a column called "ShowRevenue", for example and it would contain values Yes and No. In your ETL, duplicate the data, but in one set of the duplicate zero out the revenue column and make the ShowRevenue column No. In the other set of the data that has the revenue values, set ShowRevenue to Yes. Then, create a PDP policy that has the people that can see revenue in one group base the policy off of ShowRevenue = Yes and then another policy for those that can't see revenue and base it off of ShowRevenue = No.
If you haven't looked at this example, this may help. Although, they didn't duplicate the data, the filtering on values concept is the same.
https://domohelp.domo.com/hc/en-us/articles/360042934614-Creating-and-Deleting-PDP-Policies#5.
Hope this helps.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.2
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive