verytiredgirl Member

@ColemenWilson no, not yet. So I have a multi-lines charts with x-axis = ship_date, y-axis = sales, series = province → drill to line chart as well with same x and y-axis but series = branch. The date range for both cards are Feb 1, 2023 - Sep 30, 2024, by YEAR *the ship_date column formatted as 'yyyy-mm'dd' When you click…

Thank you for the response. Yes all my numbers are negative. However, I also have legend on the side of the pie chart, so if create a BeastMode that uses ABS() & drag that BeastMode into Pie Value, the legend will show all number in positive (which is not what I'd like to show unfortunately)

I have not tried it yet and I'm also new to Inline Editing so I'm not sure how to join the updated column to the appended dataset, could you explain it a little bit more? But I do have a webform that basically has the same as the Output Dataset, but with the commentary columns. Then I left joined the Output Dataset (left)…

@PhoenixDev Yes, I just tried that and were able to have the legends next to the end of the line and also have the Values show on each lines as well

@ColemenWilson Thank you, it worked. However, I forgot to mention that I also have Values showing on Data labels (numbers on the lines). So I guess I won't be able to show both values on the lines and legends at the end of the lines?

Thank you for the response, yes I can provide a sample dataset with random numbers: For my Pivot Table, I just dragged Class 1, 2, 3 into Rows, and MTD, MTD % Beast Modes into values I tried the new MTD Beastmode above, I was only able to returned the Sales Amount and not other GL Account Amount, hence the MTD % won't work…

I tried, and I got this error

Yes I can provide a sample data here (the sample only has 1 month of data) And I'd want to replicate this MTD % column in the Pivot Table: Sales is 100%, COGS → Interbranch Charges = % of Sales Cost of Other Sales % = (Count Variance % + Obsolescence % + Supplier Rebates % + … + Interbranch Charge %) Gross Profit = Gross…

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