verytiredgirl Member

Thank you for your answer, it was very helpful. However, I don't quite understand this BeastMode: CASE WHEN <month variable name> = month(<your date field>) AND (<year variable name> = year(<your date field>) OR year(<your date field>) = (<year variable name>-1)) THEN 'Include' ELSE 'Exclude' END Isn't it doing the same…

Thank you so much, I'll try this. I haven't created any variables before so quick questions on creating them. So right now I only have data from Feb 2023 - Sep 2024, but I'll update this dataset in the future. When picking a year it should start from 2024 onwards, do I need to add 2025, 2026 in the variable right now, or I…

Is the Shared Repo the same as Linked Repo? I read upon Linked Repo and it said "linked repositories allow you to migrate existing production dashboards and DataFlows to a development instance without making changes in production". And I'm not sure if that would work. As for my case, our team use a shared account in Dev,…

@ArborRose thank you for the response. However, problem with that is that in GL Records, some branches have "Addons-Repairs," "Restocking Charges," and "Contractor Discounts" and some may not. Same goes with Month, so some month will have those GL and some months do not. So basically the join cannot distinguish which…

No I do not have those options in the dataset history, just the two options I sent above in the attached picture

Thank you, I changed the BeastMode name and it worked

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