DashboardDude Contributor

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

@luizalauretti no problemo. Glad you got it!

Hi @clairepmcc , Funny enough, I just answered this for someone else. So your better bet is to use the CAST and CONCAT function to make a date like 2022-09-01 and then you can change how it is displayed to be 2020-Sep or whatever you want. Here's a video I made showing it:…

Hi @luizalauretti, So you need to use the CAST function and the CONCAT function to take year and month and smash them together. Then CAST makes it a date. Here's a video I made for you to watch: https://www.loom.com/share/687c0aa3858a48f8a06602ec754a2426 John Le You're only one dashboard away. More video solutions at:…

Hi @HowDoIDomo , So the start of that 4** date is Jan 1, 1900 so you need to create a column in an ETL with that Date and then add your number of days to that date. I made a video for you to see: John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry

Hi @mroker , So first, you'll need to do a bit of data cleanup. Having the names of the months at the top isn't the best hygiene, but I have you covered. If you can get your data to just be Category, Date, Sales, that's cleaner. If not, you can transform it. Anyway, after that, you just need some basic formulas to get MTD,…

Hi @Mike_Shrift , One thing you can do is to make a filter. So if you have a card that is a table, you can write a formula/beast mode like CASE WHEN `date`>=(Curdate()-5) AND `date`<=(Curdate()-2) then 1 end Then you'd filter on 1s. Make sense? John Le You're only one dashboard away. More video solutions at:…