Domo Detailed Dataview Duplicates (DDDD)
Hi Domo Community,
We are running DOMO on top of Snowflake DB.
My problem relates to a detailed view of a card, something like this:
To get this results displayed, DOMO runs a DB query which looks something like this:
SELECT <columns>
FROM <the table>
LIMIT 50 OFFSET 50
If the dataset is bigger than 50 rows, you need to scroll down using the slide bar to get another 50 rows loaded into the DOMO view:
Now, when you do that, the DOMO engine runs exactly the same query as above to retrieve the rows.
SELECT <columns>
FROM <the table>
LIMIT 50 OFFSET 50
I think you already see my problem, anytime i use the sidebar, it loads 50 random rows from the WHOLE dataset, so eventually, the DOMO view ends up with duplicates or missing rows entirely.
I also know that the SHARE/EXCEL EXPORT button works well, as the LIMIT in that query is rather huge, but I'd like to fix the results in the DOMO data view.
Is there any way or a trick how to remedy this issue?
If there is a thread about it, please direct me.
Thanks,
George
Answers
-
Hi @George_LL
This sounds like a bug. I would reach out to Domo support and raise this issue with 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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 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
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive