verytiredgirl Member

ohhh maybe I should have mentioned that my real dataset has more than Sales & Cost of Sales, It also have Office Expenses, Building Expenses —> which eventually, I would also like to create a 'Total Expense' row

My Class 3 only has Sales & Cost of Sales, so if I drop Class 2, it will only show Sales & Cost of Sales. I have a sample dataset here

I ran into the same problem, did DOMO ever get back to you on this or did you find other solutions?

@ColemenWilson I think it's slightly different for my case. So instead of forcing a selection on a Filter Card. I want to force a selection on a Bar Card/Chart, with an option to filter with a Filter Card later on.

@rco thanks for this, but might I ask why it's a cross join? because my end goal is to have a Pivot Table that has column: MTD, MTD %. With the Cross Join, the MTD Amount will be inflated in the Pivot Table

@GrantSmith thank you, it worked for the YTD. Also is it possible to use Rank & Window Tile Lag to calculate MTD Last Year & YTD Last Year? Or should I just go with Formula Tile instead?

@MattTheGuru Hi Matt, I'm pretty sure those are useful for DOMO developers (someone who use DOMO to build visuals). I am looking for similar content but for the End Users (someone who just use the app/dashboards)

Thank you for the reply! I also do not have the data for January yet so I couldn't test it out. But (Year Selector = Fiscal Year + 1 AND Month Number = 1) -- Include January of the next calendar year) AND Month Number <= CASE WHEN Month Selector = 'January' THEN 1 this YTD would only return January 2025, so maybe changing…

@ArborRose That could be feasible but with my Year Selector variable, changing Jan to 13 may not work. For example: if the Year Selector = 2025 and the Month Selector = January, the calculation would include all months from February to January of the following year (since January is represented by 13). Therefore, January…

@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…