verytiredgirl Member

hi @chetan_cricut, did you every find a solution to this problem? If yes, could you share what worked for you? I'm in the same boat wanting to show a slicer with individual and an All option

I'm using radio button and I don't believe it has the option to choose All. Drop down selector, only has clear all selection, don not have select All. Check box and Slicer, I can defeault selecting All, but then when an end user want to see Tiktok, they would have to deselect Facebook & Instagram, which is a lot of…

Thank you, Is it possible if you could add other metrics in this same alert? An example alert: "Sales MTD: [Sales MTD] decreased by [YoY] comparing to MTD Last Year"

have you ever found a solution for this?

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