DashboardDude Coach

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.