I want to use this new text card to insert the summary numbers. It worked fine with most scenario, but I am have difficulties to report the last date and to set up the filter to get the last date visits of my dataset.
for example, 3/31/2020 is the last date in my dataset, then I want to show:
"On 3/31/2020, total 5023 visits"
How to set up the date filter so that it aways pick up the last date of the dataset?
The beastmode with MAX(date) will change its value every day and will require you to change the value to be filtered every day.
You should try in the Dataflow to create a new column to use as a filter. For example,
WHEN date = MAX(last_date) THEN 1 ELSE 0 END AS is_last_date
Then filter when is_last_date = 1
@marisaborges thank you for your idea. But I am not sure it is doable in the dataflow - this dataset has 120 million rows and 200 columns, in order to reduce the run time, I had to run the whole dataflow for 2018, 2019, and now just run dataflow for 2020 and append to the 2018 and 2019 dataset using data assembler. Not sure how to work it out.