DashboardDude Coach

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.