-
Re: Toggle series in bar chart
@jrtomici Yes, variables can be set as controls that users can change on controls and dashboards.1 -
Re: Calculated Column using Current Date
@JenHarrison It looks like your missing a ) after CURRENT_DATE which is resulting in the syntax error. Though you will probably want to use the DATEDIFF() function instead as in your current beastmod…4 -
Re: Creating a Pass/Fail Test in Magic ETL
@gbrown I would suggest doing this by splitting your dataset once you have the Pass/Fail beastmode created as written. Have a branch that filters to just the fail rows and then you can select just th…2 -
Re: Number of Posts Published
@gump Try a COUNT(DISTINCT 'Blog Post') beast mode for your Y-axis. This will count each unique blog post only once for each month.1 -
Re: Count Distinct with Fixed?
@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_RAN…3