Calculations based on Page sync time
Comments
-
You could create a beast mode function to look at the time difference between the current time using the NOW() function and the timestamp of when the dataset was last run which is _BATCH_LAST_RUN_, like this:
TIMEDIFF(NOW(), `_BATCH_LAST_RUN_`)
You could DATEDIFF if you were looking at days instead of minutes and hours. There are a number of date & time functions available for use in the beast mode formula editor. Look through the list of options if neither of the above work for you.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thanks for your reply! I'm aware of these calculations, however, I'm looking for a solution where the beast mode refreshes every time the card is refreshed instead of only when the data set is updated. For example, I have a data set that updates every 15 minutes where the last timestamp in the data runs about 12 minutes behind the update timestamp.The way the calculations currently work, if I subtract the last timestamp in the data from NOW() it will show 12 minutes, which is correct at the time of update, but, if the dataset somehow doesn't update for an hour, the calculation will just show 12 minutes for that full hour instead of growing. I hope this makes sense.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 202 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 180 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive