how can I update 0 record in Google Analytics Real Time Connector
I used Google Analytics Real Time Connector to get the "active user" data. I want to display "0" when there are no active users. But I found that the dataset will not be updated when there are no active users. What can I do to let the dataset update or clear data when there are 0 records.
Answers
-
interesting.
you'd need a dataset that tells you the last time the dataset ran and the number of rows that were updated on the last execution (have a look in DomoStats and DataGovernance). keep in mind, the stats datasets are only up to date as at the last time you executed the dataset, so you'd need to update the governance datasets with the same regularity that you're processing the data in Domo. then you can use logic (if the number of updated rows = 0 then blank the dataset.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Good idea, but how can I connect my dataset to that DomoStats Connector? I installed that app automatically, and it has been filled with data.
0 -
You'd utilize a Dataset View (Beta) or a DataFlow to join the two datasets together. There's a DataSet ID you can utilize in the governance datasets to filter for your specific one. It's a 32 digit hexidecimal (letters and numbers) value. You can get it from the URL when viewing the dataset in Domo.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive