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 to any 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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive