Best Of
Re: String to date
@damen I'd suggest using the STR_TO_DATE function in the formula tile. Since there may be 5 or 6 digits, you can use the LPAD function to add a leading zero if the length is less than 6.
STR_TO_DATE(LPAD(`DUE DATE`,6,'0'),'%m%d%y')
Here is the KB article with all the date format specifiers to use with the STR_TO_DATE function: https://domo-support.domo.com/s/article/360043429953?language=en_US
Re: Using date filter as input for Beastmode calculated field
@BenjaminPapes I see what you mean. The error you're encountering is because your calculation has an aggregate inside and aggregate. Does it still give you an error if you remove the outer SUM from the beast mode and set the aggregation in the drop down when using it in the card?
Re: Using date filter as input for Beastmode calculated field
@BenjaminPapes If you don't want the maximum date to be affected by dashboard filters, I'd recommend adding it as a dataset column in your dataflow instead of a beast mode. That way it will not be affected when you filter by sales date.
Re: Antithesis Filtering on Dashboard
@Stuck I agree that this would be a good request for the Ideas Exchange. You could also consider using a cross-join in your ETL if it's too cumbersome to manually filter 20 projects.
Re: New nested statement
@kodonnellLT What field is supposed to be greater than 111? You are missing that field, so it should be:
case when `Status_c` = 'Booked' and `Field` > 111 then 'Tier 4' else 'Tier 1' end
Your last example won't work because you're doing an aggregation without any grouping.
Re: Dynamic Chart Height
This would be nice for exporting reports/dashboards as well, if you would be able to export a table/dashboard, and the table cards would grow, or have a "Max pages to export: " option so excel wouldn't be the only option to export tables to.
jvanis
Re: Dynamic Chart Height
I agree! Dynamic chart heights could also help with PDP. If you have a table with all rows for Executives, but you needed to limit other users to certain categories, some sort of dynamic chart height could adjust the cards to get rid of white space for users while keeping the executive "all rows" view in tact.
adeshon
Re: Antithesis Filtering on Dashboard
Hi @Stuck are there other dashboard filters that you want to apply to these cards? If not, I'd suggest disabling the filter interaction on those cards. You can do this under Edit Dashboard > Card Options > Change Filter Exceptions > Allow Filtering