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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有