Unknown Error using page filter
I've created a tab with with two collections on it, each collection uses a different data source and I've added page filters for each collection. Users with admin access can use both sets of filters with no issue. Users with general access receive "unexpected error" message when they try to use the filters associated with the second collection/data source (but successfully use the filters associated with the first collection). Both data sources are Excel files that I've uploaded to Domo. Can anyone point me in the right direction for trouble-shooting and resolving the issue with the second data source? Thank you!
Comments
-
Hi @mpoudel,
I'm not using beast mode on this collection: It's a stacked bar graph + a table. Page filters are on three unmodified data columns ("Product Grouping", "Product", and "Approval Status").
I managed to get around the error by setting up an ETL that renames two columns that were common names in both collections (see attachment). While working with a client, I noticed that Product still showed up as a page filter on collection 2 even after I had removed all the page filters for collection 2. Product is also a page filter of collection 1. My assumption was that having similarly named columns/page filters in two data sources on the same page was causing issues.
Although the ETL got around the problem, these two columns are found in alot of the data I'm working with. It would be very nice to be able to resolve the problem without having to set up an ETL just to rename columns. Your thoughts?
Thank you!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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