verytiredgirl Member

I tested it out, however, once it gets to '2025-01-31', it returns Previous Month as null, when in fact it should return the Amount for '2024-12-31'. And it a repeated problem with every January

@_DanielB_ hi, did you end up finding a solution to this? If yes, could you share with me, I'm in a similar boat. Thank you

@DavidChurchman Thank you. Yes, slicer card is a better choice

Thank you @ArborRose. I tested them out but none can show the Change Value = 108.69% correctly Option 1: Gauge Value = (YTD Budget / YTD) * 100 = (12.76 - 11.75)*100 = 108.68 Comparison Value = 100 → the change value in DOMO calculation = (108.68 - 100)/100 = 0.0869 → which is not what I intended to show Option 2: Keep…

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…