-
Re: Can I show a percentage of a Summary Number underneath the Summary Number?
@Cartergan and @Joe_M , you can use HTML in summary numbers to create a ... formatted summary number: https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/HTML-in-Summary-Number/m-p/22473#M2517 try creat…3 -
Re: Negative value as 0
CASE statement? Case when sum(amount) <=0 then 0 else sum(amount) end3 -
Re: Decline in Survey Responses?
I can't answer if 'people are doing fewer surveys' but there are some established ways to measure the effectiveness of your survey. A/B testing is possibly one of the more better known and easily und…3 -
Re: Filtering beast modes using Card Start and End Date parameters
If I understand your question, you're trying to create a parameterized queries. that doesn't really exist in Domo, so you can take a MySQL dataflow esque approach. Basically create a webform with the…3 -
Re: Sum of Distinct Count Variance
So ... while window functions are amazing for many things, it won't work when you're trying to do a count distinct. why? SUM( COUNT(DISTINCT CASE WHEN `Year`= YEAR(CURRENT_DATE()) AND `Month #` <=…2