DashboardDude Coach

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…

Hi @Katie_Forrest_2022 , Trying to understand your above message so I may need some more context or examples to see to help. So what is the result you are seeing? You're getting 100%? If you were to break this out, what do you get for a numerator and what do you get for a denominator separately? John Le You're only one…

@HowDoIDomo , Happy to help!

Hi @chrissy , You are basically there. I think you just need to move your "sum" to the front of the line. Here's a video I made for you showing you how to do so: https://www.loom.com/share/d57f4594c62245d5b3a4f3fcf5dd22a8 John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @WorldWarHulk , Not sure if this will help, but in Domo Governance, you can pull who has access to pages. As for Cards, not sure what to do there. I have a feeling you knew this already though so let me know if this helps. https://www.loom.com/share/25de438386db4724b35ffaa2a235af97 John Le You're only one dashboard…

Hi @gdude , So in your calendar chart (right picture) you have that value set to count of values and not sum right? Is that what you're looking for? For Dec 14 to be a lighter color because it's only 1 value? John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @user006099 , What if you create a variable in a webform or something and have that feed into an ETL that produces your output for your word cloud? John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry