Beast mode to generate Batch Date?
Is there a Beast mode that can generate Batch dates? A colleague of mine has a dataset that updates monthly, but does not include a date column. The internal clients who view the report would now like to see a breakdown by date.
Is there a way to use a beast mode, or some other tool, to create a batch date calculated field? The only things I've found are to set the current date as a batch date.
Best Answers
-
You can use a magic ETL and a formula tile to tack on the specific time your dataset was imported. It wouldn't match exactly to your system's date but would allow you to have a date tacked on in your dataset every time it's imported.
You use a formula tile with the formula:
CURRENT_TIMESTAMP()
If your data is being overwritten and you want to keep a history you can change the update method of your output dataset from Replace to Append (or Partition if you want to only have a single version per month).
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@HowDoIDomo This is certainly not an elegant solution, but you could download each batch uploaded from the dataset history and manually add the updated date to the file to create your historical dataset. You would have to start with the very first time the dataset was uploaded and work your way forward.
0
Answers
-
@HowDoIDomo Is there some sort of identifier in your dataset that you could use to determine the date or month?
0 -
You could look into using data from the DomoStats/Domo Governance datasets to get the batch date and then join it to your main dataset so it would be available as a column on your card. Look at the Datasets or Dataset History reports from the DomoStats connectors.
**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.0 -
😓 I don't think so. They only date marker they can think of is the upload date. But, the dataset is set to replace. :(
0 -
Are you saying that your report viewers want to be able to select a date and view the data as of that date, but your data is set to replace so there is no historical data?
**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.0 -
You can use a magic ETL and a formula tile to tack on the specific time your dataset was imported. It wouldn't match exactly to your system's date but would allow you to have a date tacked on in your dataset every time it's imported.
You use a formula tile with the formula:
CURRENT_TIMESTAMP()
If your data is being overwritten and you want to keep a history you can change the update method of your output dataset from Replace to Append (or Partition if you want to only have a single version per month).
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@HowDoIDomo This is certainly not an elegant solution, but you could download each batch uploaded from the dataset history and manually add the updated date to the file to create your historical dataset. You would have to start with the very first time the dataset was uploaded and work your way forward.
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
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive