DashboardDude Coach

@luizalauretti no problemo. Glad you got it!

Hi @clairepmcc , Funny enough, I just answered this for someone else. So your better bet is to use the CAST and CONCAT function to make a date like 2022-09-01 and then you can change how it is displayed to be 2020-Sep or whatever you want. Here's a video I made showing it:…

Hi @luizalauretti, So you need to use the CAST function and the CONCAT function to take year and month and smash them together. Then CAST makes it a date. Here's a video I made for you to watch: https://www.loom.com/share/687c0aa3858a48f8a06602ec754a2426 John Le You're only one dashboard away. More video solutions at:…

Hi @HowDoIDomo , So the start of that 4** date is Jan 1, 1900 so you need to create a column in an ETL with that Date and then add your number of days to that date. I made a video for you to see: John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @mroker , So first, you'll need to do a bit of data cleanup. Having the names of the months at the top isn't the best hygiene, but I have you covered. If you can get your data to just be Category, Date, Sales, that's cleaner. If not, you can transform it. Anyway, after that, you just need some basic formulas to get MTD,…

Hi @Mike_Shrift , One thing you can do is to make a filter. So if you have a card that is a table, you can write a formula/beast mode like CASE WHEN `date`>=(Curdate()-5) AND `date`<=(Curdate()-2) then 1 end Then you'd filter on 1s. Make sense? John Le You're only one dashboard away. More video solutions at:…

Hi @chapman So I think you're close, but just need to move some things around. I made a video for you to show you how: https://www.loom.com/share/295fd98f101c4ef0b5a6a7e6ddce4363 Good luck, John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

@gsharma Ah okay. So I think you have to pick your poison. 1) Option 1: Make the artificial filter of a 1 if the quarter is a previous, current or future quarter, but then you can't use that same card if someone wants to choose a different quarter unless they open editor and change it 2) Option 2: You CAN make a filter at…

Hi @gsharma , A bit confused so looking for clarification. In your first paragraph you are saying you want to see previous, current and next quarter, but in the second you don't want to do the fitler on those 3 because it would limit the chart to only those 3. I'm not understanding because it sounds opposite of what you…

Hi @vivekmani28 , Unfortunately I don't think so. It's because the when you select 2022 you're basically filtering out 2021. So if you select 2022 and 2021 you might get it to work. Let me know if that works. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @nshively , So I think I've done what you're asking. It's a bit of a doozy. Anyway you can share a screenshot of an ETL or something to give more context? Bascially I think you'll have to do the date operations function to calculate last 12 months by month and then use Unpivot to flip everytihing....a doozy. Let me know

@froghunter Yeah custom videos just make it easier than doing some examples sometime. I love the "We Got a Problem!" Yeah your beast mode logic is good! You will soon be AllAmphibianHunter at this pace

Hi @AndreiA , So I would make a formula that is just UPPER(id) and do the rank off that. That way you keep your case sensitive one, but also can do your rank on this new capitalized column. Let me know if that works. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @Stuck , Any way you can show the actual data or a mock up? It'd be good to see a screenshot of what these fields look like and your formula to the right in a table to gain more context.

@Buck , What about something like onedrive?

Hi @louiswatson , It could be because Sir William Wallace needed to scream "FREEDOM" louder or potentially because the map card needs to be bigger. If you expand the height of it, does Scottland still not show?

Hi @froghunter , Here are a couple ways to do it. If the last value is all the same length, you can use the RIGHT feature in text. If not, then you need to do the split to columns/ delimiting trick you were doing. Here's a video that I hope is helpful: https://www.loom.com/share/3f7c949e382a442a903a32e9005f168e Good luck,…

Hi @louiswatson , I get this question quite often. So I think you need to combined your dates into one column. Here's a video I made showing you two different ways to do it depending on your dataset. I wasn't sure so I had to guess a bit: https://www.loom.com/share/3ac1b9a4c13a4da58ff0b6d32e152881 Good luck, John Le of…

@Thinh , Open a support ticket with Domo or email support@domo.com and paste in the URL to your dataset that is taking too long. They can look into it. I've done this several times. John Le More Domo solutions at https://www.dashboarddudes.com/pantry

Hi @quez , Happy to help, but I have a clarifying question. If you see 20221201, how do you know if that’s December 1, 2022 or Jan 12, 2022?

Hi @gbrown , What if you don't do any OR statements or AND statements? For instance, you'd do this: WHEN `ComplaintDesc` LIKE '%ICE%' THEN 'ICE' WHEN `ComplaintDesc` LIKE '% ICE%' THEN 'ICE' Curious to know if that works John Le More video solutions at https://www.dashboarddudes.com/pantry

@Mickey here you go: https://docs.google.com/spreadsheets/d/1M6yvCfH5RI93H_Vg8sEFWhU1WrRIP9a7UgrFnjKdpl4/edit?usp=sharing John Le More video solutions at https://www.dashboarddudes.com/pantry

Hi @gbrown , So you're going to go have to do 2 steps: 1) Determine which cells are truly numeric 2) Convert the numeric ones to dates Here are the formulas to do the steps: 1) CASE WHEN STR_REMOVE_DIGITS(`Date_Temp`)='' THEN 1 END 2) CASE WHEN `Numeric Format Flag`=1 THEN…

Hi @Julie_H , Got it. Feel free to book 30 min with me and maybe I can take a look. I think I need to see what you're doing to help. Again, only if you want to. https://www.dashboarddudes.com/book-a-dude Happy to help, John Le More video solutions at https://www.dashboarddudes.com/pantry

Hi @Julie_H , So I think you should use a formula trick called "Interval". I answered a previous question around previous dates here: https://www.youtube.com/watch?v=LQZS8NKX-Gg&list=PLLbgJInsMl7o3pPpLmyVe1AsxwX2OEJGO&index=2 So you can saw date - interval 5 day or date- interval 1 year etc Let me know if this makes sense,…

Hi @DavidSawyers , Just to be clear. It sounds like you have 3 tables in a dashboard and you want to send the CSV from each of those as attachments, but in one email. Unfortunately, I don't think you can do that. There are some alternatives I have here so hope that helps:…

Hi @rumoredcs , Unfortunately, you can't add numbers really in the way you have data and have date filtering functionality. You'll have to transpose the data using the unpivot functions in the ETL. Here's a video I made for you to follow along: https://www.loom.com/share/242bc551ed8e4d4c9c2c011b13d499d3 Good luck, John Le…

Hi @MDavis , Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0. Good luck, John Le More videos at: https://www.dashboarddudes.com/pantry

Hi @damen , So you really can't do this because SQL can only look at numbers on the same row. So you'd have to remove that First Mortgage column for your Loan Count Column to finally sum. I actually just did this for another Domo user:…

Hi @JasonKerr , Always trying to impress. So I think then you just have to put in those parameters like Gender, College level, etc in the Group By top part. If that doesn't work, feel free to schedule a free 30 min with me and we will knock it out together: https://www.dashboarddudes.com/book-a-dude John Le More video…