DashboardDude Coach

Hi @Data_Devon, So I've done this with a lot of PE firms. Honestly, from my experience, the answer comes down to how many people need to adjust numbers. If it's just you and you want to go down the Domo path - go for it. HOWEVER, if you have a lot of other finance people who need to give input or make adjustments, I have…

@briang001 Let me help with that distinction. So this link is ALL the chart types you see from the analyzer when making a card: The bricks stuff are charts that require some coding and you can find that by typing Bricks into the appstore: Hope that helps with the clarification. Here's the link again: Also if you want to…

Aw thanks @Data_Devon . @briang001 Here's a page I made that has all the available chart types that aren't bricks: https://www.dashboarddudes.com/recipes

@Data_Devon we are fire brothers!

So many goats like @ColemenWilson and @akeating. They are grazing on the Domo Community Forum

Hi @Tcole , Here you go: If doing this in beast mode/ SQL: CONCAT(LEFT(`whatever the date column is named`,4),'-',SUBSTRING('whatever the date column is named',5,2),'-',RIGHT('whatever the column is named',2)) This will just give you a string though. If you need it to be a real date then in the ETL you can do the same…

Of course @ColemenWilson is the GOAT

@Data_Devon I have the power!!!!!! Happy to help. If you want to get regular updates and tips from me, feel free to join my newsletter: https://www.dashboarddudes.com/newsletter-email-signup

@Abe happy to help. If you want alerts on videos and tips of mine, here's a link to join my newsletter: https://www.dashboarddudes.com/newsletter-email-signup

Hi @Data_Devon , Not sure if this helps, but trying. Here is a little video with my answers: https://www.loom.com/share/d931a3a1c5c84ecc9954af0f27dc08cd?sid=0c668c51-ecec-415c-be14-c8653bf29b0f

@AndreaHenderson These are great

@Abe , Hope this video helps. I made this for you to see if I'm answering the question: https://www.loom.com/share/db3f2400b3c54ca8950d914ed4ac1c03?sid=248e6d4a-8fc0-4393-abac-f24329b8518b

@chetan_cricut That's what I'm actually saying. Pivot Tables don't have the option for a heat map. So if you wanted anything like it, you would need to do a megatable but make each year it's own column.

Hi @chetan_cricut , Not for a pivot table. If you really want the heatmap you will have to make your date columns you want their own rows which is kind of a pain. However if you flip and have the dates as rows going from up and down instead of left to right then you can do a regular table with the heatmap.

@ColemenWilson this is what I setup for my clients right away.

@Jbrorby , Ah okay I understand now. Hmm I unfortunately do not know of a work around.

Hi @RTM , Unfortunately, I don't think you can do that for this chart. The code you have doesn't really work because we are in SQL and assigning things to color names is a very HTML thing. These are charts are usually one color per bar. HOWEVER, there are other charts that might help. For instance, you can use a regular…

Hi @hmadari , Truthfully, I've only used the regular Snowflake connector (which is very good) and done all the partitioning, etc in the ETL, but looks like there is this specific connector for snowflake partitioning. I would suggest you just use both to test.…

Here's that page if you want to see the whole template: https://www.dashboarddudes.com/templates

@Stefano, So one thing that I do is I like to make tiles which are independent of the table. That way you can make it whatever you want. Instead of ROAS across the row you can make each a KPI and do sums or whatever you want. I have found from my experience that if the number is super important - just give people the damn…

Hi @Data_Devon , I'm also happy to help. I have courses people can take to learn Domo if they wanted. In addition, I can fly out and do 2-day Domobootcamps where I teach teams live to get everyone on the same playing field and then dedicate the last 2 hours of each day to do office hours where we crank out whatever is…

Hi @Stefano , Just to clarify, in that column you set the aggregation to be MAX, but you want the Total Row to show a Sum of the numbers instead of the Max right? If that's the issue, then I think the answer is no because the total is based on what you are aggregating. HOWEVER, you can set the summary number to be a sum…

Hi @art_in_sky , Unfortunately not because each file would be it's own dataset. So if you brought them all in at once, Domo wouldn't know what to name anything. HOWEVER, if all the files are the same format , then you can do a little trick to combine them all into one file and bring that into Domo once. So the question is…

@AndreaHenderson Just tried this and little things like this save me massive amounts of time in the long run. Appreciate all this!!

@verytiredgirl Here's the video on Youtube: https://www.youtube.com/watch?v=ZMO9DSRHous

Hi @verytiredgirl , I too am very tired…always. I made a video answer to show you some other ways to get what you're looking for: https://www.loom.com/share/e7ed0fc24db2472cbaf39fafa022ef3b?sid=c57b10fa-5a9b-4833-9ffd-3d9862f22ddd

Hi @calvert_schaefer , You could use variables to help you out instead of using the prebuilt compare to fields in the date dropdown. I made a video to show you: https://www.loom.com/share/601578f4d58149aeabc5fcc1c6ac4bab?sid=36378d0e-22b0-4a88-bfcd-7a7d3569bc7a

Hi @Data_Devon , I made a video answer to hopefully answer this for you. You have a couple options such as Xing out the filters on drill paths or just making the card open another card when clicked.

Hi @dianemairet , Yep you can use a bunch of different connectors that pull from file name rather than file ID. I made you a video to explain this better: https://www.loom.com/share/f8b38ceba0014fe58e46c25c7cf62248?sid=331ef3f6-e94c-4275-a48e-335fe3646b6b

Hi @dianemairet , Your best bet is probably to use Domo Workbench. That way you can just schedule it. However one thing is your computer has to be on for the program to run.