DashboardDude Coach

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…

Hi @Jim_C , So you can pull in Source Medium from the GA connector as @GrantSmith mentions. Then if you use Advanced Filters, you can select any filter you want. Domo actually has a filter builder which is WAY COOLER than it used to be. I used to have to write in some gnarly JSON code, but now Domo will do that for you.…

Hi @JasonKerr , Thanks for the clarification. Here's a video on the solution: https://loom.com/share/489fb795c735401681896cda6859402e Issue was that you need a constant. SQL can only do math of a number if another number is on the same row so you have to use an ETL and the Group By function to make that constant. Take a…

Hi @JasonKerr , I think I need to see it to do more, but your SQL formula looks like it's missing something. So when you write Case when statements you have to have the word "end" at the....end. Here's an example of what is written: SUM(CASE WHEN `Interview Round` = ‘Second Round’)/SUM(CASE WHEN `Interview Round` = ‘First…

Hi @utkarsh , Can you share a screenshot for more context?

Hi @wilbaile , One option you have is to put their emails so schedule a report to your clients each day, week etc. It will just be a picture more than a PDF, but you can attach the underlying excel file as a table if you need. Your BEST option though seems to be to just allow exporting on your embed options. Here's a video…

Hi @renee12345 , What's the datasource you're pulling data from? I ask because if there's something like a Last Run Date or something like that, you can leverage that.

@zuchu you're awesome and don't forget that.

Hi @Shane_Lester99 , Can you send a screenshot of the ETL? I bet you have one step that is the culprit and taking forever. May be a join or something.

Hi @zuchu , So you need to make a lookup table and then write a formula to say when your location field is blank to pull from that lookup table, otherwise just keep the location formula you originally had. I made you a video to make this easier to follow: https://www.loom.com/share/421ffb74198345c49ae466c851a1d103 Good…

Hi @Mattwjones , So shopify is a bit of a beast. If you need revenue, I would suggest just pulling from the Orders report. However, if you need to know progress of individual products, you'll have to use the Order Lines object. It's quite a doozy becaus the order lines report, double counts revenue becase there are usually…

Hi @PRC Here's a quick video to help. Truthfully, I don't think I have enough context, but hope you can see some tips from this video: https://www.loom.com/share/779575aed8854ce689c3ec0981175e47 John Le https://www.dashboarddudes.com/

Hi @anh_tr_huynh4 . Here's a video explanation of what you need to do: https://www.loom.com/share/70b71aee2ec44253bb4638c9862f50cb Anyway, you're on the right track, but I don't think your formulas are doing what you want them to do. By using the year and month functions, you're really saying to get a sum of invoice…

How to enable security settings with the Domo embed feature.