DashboardDude Coach

@Atieh and @Data_Devon please eat some goat biryani in my honor

Hi @Atieh , What happens if you change FY2 in your target area from Sum to Max?

Hi @RTM , Trying to understand. So you want to be able to select "current month", but that goes up to the last day of February? Apologies, I'm just not understanding the request, but I bet we can help.

@giannzi why don't you just filter for majors ending with BS before the rank?

@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:…

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…