Best Of
Re: Sum if using Case When
Try moving the SUM to the outside of your CASE statement instead of being inside. I would also double-check your data to make sure you are matching exactly, such as case-sensitivity and extra spaces.
Re: Sum if using Case When
Try this:
SUM(CASE WHEN `Data` in ('Goal','Pipeline','in P&L') THEN `Total` ELSE 0 END)
This should get the total you want.
Re: Filtering Report Data by Multiple Dates
@Brightsider you can but you would have to restructure your dataset. You'd need a single date column to filter off of, so you'd want to pivot your data to create a single date column, and then have a new label column that holds the value of "Created" or "Scheduled"
mhouston
Re: Copy an entire dashboard
@damen Yes, if you click the wrench in the top right corner of the dashboard and select "Save As" you can copy an existing dashboard.
Re: Dataset refresh failure notifications
We had a similar use case and created a group email address, set up a user in Domo with that email, and then made that user the owner of the process the group needed a notification about.
akeating
Re: Dataset refresh failure notifications
Currently it's not an option until they allow group ownership of datasets. You could utilize an email address that would then forward emails to a group but that would have to be handled in your email server outside of Domo.
Re: Dynamic Rank Beast Mode
Are you using RANK in a window function? It sounds like you don't want any missing numbers in your sequence. Rank will ignore numbers if there are ties in your dataset. In this case you might want to try DENSE_RANK instead as that won't have any skipped rank numbers.