verytiredgirl Member

hi @WizardOz, just wondering how did you create the indicator in the dataflow?

@brycec, thanks for the suggestion, but does it scalable or is there anyway to make it scalable? I have hundred of sales rep and each of them has hundred of customers, with the suggestion, it seems like I have to search and add each customer individually when setting PDP for each sales rep?

Thank you @MarkSnodgrass, I've used bullet chart before, it does show all the KPIs but I have a problem with upper target limit not the same length across all KPIs.

Thank you @ColemenWilson, that's exactly what I'm looking for

Thank you @MichelleH. I set the default Date Range to 'Previous Month' in the filter view but the 'Date' drop down filter won't show '2025-05-31' unfortunately

@DanHendriksen Yes it is something that I do frequently hence I'd like to use workflow for this (as it can be applied to other App as well). I do know it is a powerful tool, I did watch a couple of tutorials on workflow and get a general idea but I have yet to see one where you can use work flow, find a list of people to…

how did you format your dataset? If you don't mind sharing the file, thank you

@neilprobst how did you do the group by the get the max rank?

@jaeW_at_Onyx Thank you for the video. I have a question on using View. When I did the group by User and Exam to get the Sum of Score, the original column `Score` would not be in the dataset after the Group By. Then how did you use SUM(`Score' ) in the BeastMode to calculate the percentile rank? Thank you

@DashboardDude unfortunately they are all existing cards. And I do have a drop down filter up top, however, there are many charts in the dashboard, the end users don't want to scroll up and down or use a page filter. Sometimes they just want sift through filter quickly in a particular chart not the whole dashboard.

I created a BeastMode follow your instruction and set the color rule like this However, the chart stay the same, no color rule were applied.

I just tried the Control, I selected 'Previous Month' and saved as page filter view for everyone. But the Date selector is selected 'This Month' instead of 'Last Month'

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…