Comments
-
@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:…
-
Hi @chapman So I think you're close, but just need to move some things around. I made a video for you to show you how: https://www.loom.com/share/295fd98f101c4ef0b5a6a7e6ddce4363 Good luck, John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry
-
@gsharma Ah okay. So I think you have to pick your poison. 1) Option 1: Make the artificial filter of a 1 if the quarter is a previous, current or future quarter, but then you can't use that same card if someone wants to choose a different quarter unless they open editor and change it 2) Option 2: You CAN make a filter at…
-
Hi @gsharma , A bit confused so looking for clarification. In your first paragraph you are saying you want to see previous, current and next quarter, but in the second you don't want to do the fitler on those 3 because it would limit the chart to only those 3. I'm not understanding because it sounds opposite of what you…
-
Hi @vivekmani28 , Unfortunately I don't think so. It's because the when you select 2022 you're basically filtering out 2021. So if you select 2022 and 2021 you might get it to work. Let me know if that works. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry
-
Hi @nshively , So I think I've done what you're asking. It's a bit of a doozy. Anyway you can share a screenshot of an ETL or something to give more context? Bascially I think you'll have to do the date operations function to calculate last 12 months by month and then use Unpivot to flip everytihing....a doozy. Let me know
-
@froghunter Yeah custom videos just make it easier than doing some examples sometime. I love the "We Got a Problem!" Yeah your beast mode logic is good! You will soon be AllAmphibianHunter at this pace
-
Hi @AndreiA , So I would make a formula that is just UPPER(id) and do the rank off that. That way you keep your case sensitive one, but also can do your rank on this new capitalized column. Let me know if that works. John Le You're only one dashboard away. More video solutions at: https://www.dashboarddudes.com/pantry
-
Hi @Stuck , Any way you can show the actual data or a mock up? It'd be good to see a screenshot of what these fields look like and your formula to the right in a table to gain more context.
-
@Buck , What about something like onedrive?
-
Hi @louiswatson , It could be because Sir William Wallace needed to scream "FREEDOM" louder or potentially because the map card needs to be bigger. If you expand the height of it, does Scottland still not show?
-
Hi @froghunter , Here are a couple ways to do it. If the last value is all the same length, you can use the RIGHT feature in text. If not, then you need to do the split to columns/ delimiting trick you were doing. Here's a video that I hope is helpful: https://www.loom.com/share/3f7c949e382a442a903a32e9005f168e Good luck,…
-
Hi @louiswatson , I get this question quite often. So I think you need to combined your dates into one column. Here's a video I made showing you two different ways to do it depending on your dataset. I wasn't sure so I had to guess a bit: https://www.loom.com/share/3ac1b9a4c13a4da58ff0b6d32e152881 Good luck, John Le of…
-
@Thinh , Open a support ticket with Domo or email support@domo.com and paste in the URL to your dataset that is taking too long. They can look into it. I've done this several times. John Le More Domo solutions at https://www.dashboarddudes.com/pantry