verytiredgirl Member

Thanks for the quick response. It worked, no more duplicates for the joined dataset

oh that must be why, I did hit Save before the Preview, thank you!

Thanks for the reply! How would you suggest creating a new column for Dataset 2? Should it be done in Magic ETL? For Dataset 1, I have a month column (integer values 1, 2, …, 12) and a Beast Mode “Month Name” that uses a CASE WHEN statement to convert the month integer to its 3-letter abbreviation. In Dataset 2, using…

Thanks for catching that! I forgot it's an end of month kind of report, I need to update my Beast Mode to reflect last month then, thank you!

Hi I added year in my BeastMode, but the current value still show '0.00'

the data is a bit sensitive but I can show you card the title after I drilled down sales to a specific year for a particular region:

Would this work if my Field/Column is a Date column with a format yyyy-mm-dd? I was able to do the BeastMode 'Date*1' but then I couldn't use that Date column for card visuals. P/S: I have Sales trend over year —> drill down sales to a specific year (that's where the drill down card title show '2,024' instead of '2024')