Using Latest Batch ID or Batch date
I have seen complicated ways to just use the latest data within a dataset - and I couldnt understand how to set them up.
does anyone have a simple way to just use the last batch data?
Currently I am just filtering to BATCH_ID Greater or equal to and entering latest number, obviously when the batches run I then have a few figures listed and manually change the lastest number again, that way I dont loose the old data but can see when a new batch has run.
Thanks
Best Answer
-
I never got a notification that you responded! Bummer!
Okay, I have added a few more points in bold for what will hopefully make it more clear.
When you read the steps I outlined, go ahead and type out the SQL statements manually instead of copying and pasting from the Word document.
I have shown where if you start typing the input data set name, DOMO will suggest an option with a green icon. I hope this helps!
1
Answers
-
Hi there,
Assuming your Batch Id is a numeric value you could use a beast mode that might look like
MAX(`Batch ID`)
Change 'Batch ID' for the name of your actual column And then in your card place that beast mode you've created as a filter. There is a list of supported beast modes and their functions here.
Jarvis
0 -
Hi, Unfortunately this does not work. I have a running figure of about 100 every batch run. If I put the card table columns as the 'MFA required' and this filter, the data I get is - a total of all 'MFA required' batches and the Max batch number. I am trying to just show the last figure (which is currently 115). I am currently having to seperate by batch last run date and time but also add a filter of batch ID >
0 -
Am I correct in assuming that your original data set is updating using the "Append" method? If yes, I think we can get you what you need with a SQL data flow.
I have attached a Word document with an example that I hope will help you get the data you need.
Let us know if this works or if you need a little more tailored solution
0 -
I have tried to create one of these but is doesnt seem to recognise my dataset name!
This displays as "InfoSec O365 MFA Summary" and also when selected shows as "infosec_o365_mfa_summary"
I have tried both and neither are recognised in the SQL statements
Simon
0 -
I never got a notification that you responded! Bummer!
Okay, I have added a few more points in bold for what will hopefully make it more clear.
When you read the steps I outlined, go ahead and type out the SQL statements manually instead of copying and pasting from the Word document.
I have shown where if you start typing the input data set name, DOMO will suggest an option with a green icon. I hope this helps!
1 -
t thanks, That worked ?
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive