DashboardDude Coach

@miguel_bustamante Ooo I don't think so. We would need to make that number static in the ETL via a group by and then you would have to calculate that % in a Tooltip field and maybe show that. I know…that sounds like a lot. Feel free to book 30 and I can try to do this with you: https://www.dashboarddudes.com/domo-help

The Optimalogists

@miguel_bustamante happy to help!

@andyRowan, I took a look and made you this video. I think you need to add SUM in your formula: https://www.loom.com/share/6100a780e6c94949b60c7565ba2a20eb?sid=8539a057-02f3-43d4-80b2-b2e451aedfa5

@Data_Devon One trick I do if I need a "spacer" in a dashboard is I will use a textbox actually and just set the background to the one with the red stripe meaning transparent.

Hi @miguel_bustamante , You need to use dynamic unpivot in the ETL to flip everything. I made you a little video to explain: https://www.loom.com/share/32346ab597944186bd7efea0014f0b98?sid=ba1c3235-a2bc-4f41-8b16-26fa000f6c24

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!!