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.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
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 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