user09600 Member

Thank you i would like to see an example of using partitioning to delete specific records. Is it possible?

thank you for your reply. Actually this raise another question to me. Is there any feature for deleting specific records in dataset other than using dataflow(ETL/MYSQL etc)? i know the function datarepair to delete records of each update but what if we want to delete only a part of records from last run for instance

I see so are you confirming that there is no possiblity to get such columns from domo API?

Hi how you can get the _BATCH_LAST_RUN_ field? i am using dataset create from DOMO API and i couldn't find where i can get fields like _BATCH_LAST_RUN_ or _BATCH_ID_

i found the reason it needs to be an aggregation otherwhile it cannot be use as summary number

Hi like i said my summary number show it is empty even i tried to use the value created in beast mode I use current value as summary number.can you show me how you use it as summary number? maybe i missed some settings.

I grantsmith. If i understand what you meant you have summary number as 'stale' or 'up to date'? If value is stale you get an alert? can you show me how you set up the alert on top of this? what i have created is a beast mode variable : CASE WHEN MAX(DATE(`Start Time`)) < CURRENT_DATE then '0' else'1'end and use this value…

Hi Wilson, thank for your reply. Not sure to understand "The Datasets dataset last run date" Can you specify with some example?