DashboardDude Contributor

Hi @mberkeley, @spodnar, @Moose, @JerryB. So if you want to send datasets as excel files, you could use this push connector: HOWEVER, it's just a dataset that is pushed into someone's sFTP. Sounds like you all just want an attachment as excel and not a csv which I don't think is possible at the moment. Regardless if you…

Hi @Aag2023 When you use file upload, you actually need to select the tab you want to import first. So if you have 3 tabs, you'll have to import each at a time. THEN, at the ETL you can choose that input to use. Same would be with Google Sheets- you have to select the tab you want to import before you use it in the ETL

Ah okay @nshively then yeah your best bet is to do the heatmap as a table. You can also choose "Diverging" and make numbers above zero green or something and below 0 red.

Hi @nshively, If you're open to it, I would suggest using the heat map table instead of the table with heat map options. I know sounds confusing. It's like hearing "a rectangle is a square, but a square is not a rectangle" Anyway, I made you a video to show you how to do so:

Hi @Seth , One thing you can do is just make a card as a filter and then take out Admissions_email as an option in dashboard 2. I made you a video to show you:

Hi @EdOsorio , So I don't know if you can make a dependent variable and put that into the title. However, to do something similar to what you're asking for, I will usually do this method

Hi @ArborRose , Just remove the field from the optional group by

Hi @EdOsorio , I think I understand what you're trying to do, but not 100% sure. I took an attempt so let me know if this is what you're looking for

Hi @jrtomici , Would you be open to making just one dataset that combines all the datasets you need?

Hi @RB1 , Do you have Domo everywhere? I have some clients that are agencies and they embed their client's dashboard onto their website, but use Domo everywhere to hide the filter bar so that their clients cannot adjust the main filtered view. John Le You're only one dashboard away. More video solutions at:…

Hi @gtam , I just checked my BigQuery instance and I think you need Editor or above access. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @SaloniShah , I made a video for you to show you how I did it: John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @jkellams , I made you a video on how to do this: https://www.loom.com/share/5ce03a817b5a49c8b3b76b5f29bccb36 So you need to do some text formatting, but you can get the result. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @Tommy , Is this still an issue? If so, can you share a screenshot of what the concat formula looks like and the error? John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @svetlana , Yes! Very possible. ETLs actually have a hidden section called Data Science where you can do a bunch of analysis like forecasting, clustering, etc. If you don't have it, you may need to talk to your AE about it. I think it's an upcharge, but if you're using the Consumption Model for billing it should be…

This is my favorte post John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @kpmwinston , Hmm I don't think a Domo ETL join will automatically pick up which columns to use to do the join. You'll have to map them independently as 3 separte joins in the same step, but once you do it you're done! John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @RTData , I think there actually is a way to show specific views, but you need to enable this whole token verification thing. If you have a Domo Rep, I would ask him/her for the advice. Sorry can't be of more help. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @Devin_Garrison are you trying to get to the difference by minute or hour or day?

Hi @jbryer , I think the main thing you're missing is comparing the dates from today using CURDATE() I made a video for you: https://www.loom.com/share/1190186ea57a42efb49fb772bb5f0b84 John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @NathanDorsch , Not the best solution, but I hope this helps: https://www.loom.com/share/cd0cfd29478d441d923623714dfad678 John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @ncroweatstance , So first of all @grahamwalkeradv is completely correct. I just wanted to make a video to make it easier for you to follow: https://www.loom.com/share/62bc7d1e47f24ac1a46b8df9464ee16d Hope that helps! John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @gbrown , Unfortunately, I don't think you can change the line style of lines. You can do it from regresison lines, but not regular ones. What I usually do in these instances is I make one line a dark color and the other a lighter color. John Le You're only one dashboard away. More video solutions at:…

@user04600 , Sage Intacct is a pain. Your best bet is honestly just making a custom report and pulling that custom report into Domo via the connector. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @Jackie96 , I got this question earlier today so I guess it was you! Here's a video for everyone else to see how I approached this problem: John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

@dgsinclair can you share a screenshot of what the data looks like before you send? Also can you send a screenshot of the history of the email connector? It should tell you how many rows were updated John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @louisshh , Also trying to help, but still confused by what has been written. I'm fairly unclear of what you're trying to do. If you can maybe send a video instead that might clear things up. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @Aaron_Polzin_EXT , Just so I'm clear, you want the year to change based on the current quarter? Because you could do something like this CASE WHEN QUARTER(Sysdate())=QUARTER(Cur_Date()) AND YEAR(Sysdate())=YEAR(Cur_Date()) THEN X ElSE Y End Just wondering if I'm understanding it correctly. John Le You're only one…

Hi @NathanDorsch , Yeah! Just hookup the "Select Columns" Tile under Utility, connect your dataset to that one by connecting the little dot to the litte triangle. Then, in Select Columns, hit "Add all columns" and remove column CTR. John Le You're only one dashboard away. More video solutions at:…

Hi @vivekmani28 , So the trick is you need to have a column in your dataset that has like a 1 or blank for the rows you want. I made a video for you showing you how I got the 14 solution you were looking for: https://www.loom.com/share/cad8fea30bfc4d46bb81c2a75b639913 So make a column called Proxy with a 1 where you have…