Views Explorer - Invalid query, check your DataSet schema
I have created a simple dataset view that I would like to use in another dataset view... when I attempt to open it in views explorer I am getting the error message:
"Invalid query, check your DataSet schema"
Suggestions on how to trouble shoot?
The steps I followed to created the dataset view:
- Filter to exclude one value in a the 'Company' column (text)
- Add a custom column named "Attribute" with this as the entry 'Open AR' (text)
- Group on the two fields above, SUM 'Open Amount' column (decimal)
- Rename 'Open Amount' - 'Value
- Rename 'Company' - 'Business Unit'
Best Answer
-
@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.
**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.1
Answers
-
@swagner Just watched someone encounter the same error as you. They fixed it by removing the group by column and then adding it back. Renaming the column does seem to be problematic though.
**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.1 -
@MarkSnodgrass that worked! thank you sir!
1 -
0
-
I just encoutered this issue - I added a fitler today and saved the file. Then I wanted to remove the new fiter I jut setup. it showed first my filters became cal_col1 and cal_col 2 and asking me remove the references. I deleted the fitlers, tried to reset it up, but now it shows the above error and I could not do anything. Please help. This is urgent.
Thank you
0 -
@WizardOz probably worth contacting your CSM if this is an urgent problem. My experience so far with Dataset Views is that they are a bit temperamental and quirky. I'm also finding that there is a specific order in which you should do things. Doing any Group By steps last is something I try to do which has caused less errors.
1 -
@WizardOz what kind of issues are your users having? So far for me, once you get through the learning curve Dataset Views are a great tool. Opening up some great possibilities for my use case. Let me know if you'd like to have a call to discuss. Sometimes "customer to customer" is a good way to figure things out. Happy to help where I can.
0 -
Have you tried removing all of your groupings and filters and then reapplying them?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**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