Analyzer Data
Hello All,
This is a technical question.
What could be limiting the amount of data been fed into Analyzer/dashboard even though current data is in the data source?
At every step in my ETL I have current data from 1/1/2021 to today, but after running the and saving the ETL when I use it in my analyzer to visualize it, the data is capped to Dec 2022 even though the date range selection is set to All time.
From the ETL last step I filtered for dates in 2023 and they are present in the data as below.
Is this a bug and or something? Please help.
Best Answer
Answers
-
It appears you're using the Last_Production_Date as the date field in your date picker but you're filtering in your ETL based on Order_Completion_Date. Do these end up being the same data or are they different? If they're different you can try and drag the Order_Completion_Date field into your analyzer to force the date picker to use that field and then remove it.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Thank you very much but seem to not have brought all the data
0 -
@MichelleH Yes I just checked on the only filter which is just a selection of specific categories to show on the card and yes when I removed it, the date range updated correctly. However, that still shouldn't be the case as these categories have invoices as current as today so the date range should still be updating.
With Filter on card
Without Filter
0 -
@pauljames That would be very interesting. I have attached a pic of the ETL
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 58 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive