Best Of

I find it best to use a numeric sort for the heat map. I would create a beast mode for the day of the week that returns the number (1-7) for the weekday, I would also do beast mode that returns a numeric value for the time.

@NathanDorsch Here are some settings you can use to get the formatting closer to your screenshot:

• Apply color rules to subtotals under Chart Properties > General > Apply Color Rules to Total and Subtotals
• Make subtotals bold under Chart Properties > Subtotal Rows > Subtotal Font Style
• Remove the “Count x/y” under Chart Properties > Subtotal Rows > Hide Counts

@Domomon DISTINCT doesn't work with window functions, and I believe that's no exclusive to Domo, as I think that goes for MySQL and SQL Server as well. I've seen that one solution is to use DENSE_RANK() instead of COUNT(DISTINCT ), but that does take nulls into account, so just keep that in mind. If that doesn't work, you'll need to use an ETL and use a GROUP BY and joins.

Hi @louiswatson try this:

count(case when `Status` = 'Application Granted' then `Status` end)/count(`Determination Date`)

@eduardon A case statement inside a count function should give you what you need:

count(distinct case when `Status` = 'Active' then concat(`Month`,`Client`,`Country`) end)