verytiredgirl Member

Thank you, it worked!

update: I used Text Formatting, show only number → alter the column from String type to Floating Decimal and it worked

Hi, due to privacy reason, I can't share the screenshot, but that's what I did as commented above. I selected all the columns I don't want to unpivot into 1, 2 is Date, 3 is Point, the screenshot is the preview

I have 15 other columns that are not related to point, things like Customer_ID, city, email, etc and ultimately I want to pick a Customer and see their points overtime. I have just tried the Dynamic Unpivot Tile, adding all other columns that are not points to "Select which columns will not be pivoted", but it didn't solve…

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')