Phew! Works, thank you very much! :)

DATE(BATCH_LAST_RUN) as simple as that!

@Mark It works! Thank you very much!

@jaeW_at_Onyx Thank you for your response. I have two tables, one with historical data and the other dataset that gets updated every day and grabs the last 4 days. Because the data ingestion is inconsistent, I have to check what is the latest date that we have in historical and append whatever we don't have. With the help…

I did check the users values for both weeks separately, and it does return the right values. It is also a sample of the data, so it is very small and doesn't have any NULLs in it. I reached out to domo tech support, they can't figure that out either. Not yet anyway. I am following the docs and your videos precisely. But is…

@jaeW_at_Onyx I have also tried the following: sum ( CASE when week(`Update Date`) = WEEK(CURRENT_DATE()) -1 then `Users` else 0 end ) - sum ( CASE when week(`Update Date`) = WEEK(CURRENT_DATE()) then `Users` else 0 end) It shows the right result for the last week, but for the current week, it shows the sum of users for…

Thank you @jaeW_at_Onyx for the response, this should have worked, but not displaying anything for some reason. ( sum( case when week(`Update Date`) = week(current_date()) then `Users` end) - sum( case when week(`Update Date`) = week(current_date()) -1 then `Users` end) )

Hi, thank you for your reply. I have tried that as well, but it only returns 2019 Rev. I want two columns (2019 Rev & 2020 Rev) to be side by side, for comparison reason. Now if any Advertiser is not in 2019 or 2020 then let it be 0. I can't figure out the syntax for that :(

Thank you for your solution, It seems like I get the year right and the week, and it did sum the Revenue, but the only question I have now is how would I break it by Advertiser? This is what I have as an output. Which transformation should I use?

Yes, there is. The Advertiser column has a lot of values and I need to break the data by Advertiser. Eventually, I have to show the difference between the sum of Revenue of 2019 and 2020. And I want to see it weekly. So the end goal is to see something like this: Advertiser Date 2019 Revenue Date 2020 Revenue I figured the…

Experiencing the same issue. When applying multiple filters in Magic ETL, it returns 0 results. Even though I see the raw data and it's clearly there, however, can't use filters to get the sample of the data.

I am a Mac user as well and would like to know what options I have if I don't use the Workbench? Thank you.

That's what I would have expected as well, however, it doesn't get the entire dataset. Only 500k rows. Maybe this is the limit? And if so, what is a workaround. I need the entire dataset to be run. My input dataset consists of 177M rows - I want to filter it in such a way that it will only give me the filtered results. So…

Hey Mark, Thank you very much for your help! I apologize for having so many questions but I am new at DOMO and want to understand how to do basic data manipulation. My dataset is indeed very large with hundreds of million rows, is why I want to filter it. But I definitely need the accurate revenue sum - our numbers are not…

Hi Mark, I have tried this just now and the same error has appeared. I am adding a screenshot for you to see the data. I also tried just April month as I can clearly see it is there. I was able to filter the data with Magic ETL but ran into another issue where I can't group by date. All I want is to get the sum of the…