Best Of
Re: How to grant permission for a user to access an ETL dataflow?
Alright thanks. You would think Domo would make a more simpler way to do this by now. I've got dataflows with 30+ inputs and now I have to go to through all and share each on just so a user can edit a single dataflow? Seems kind of silly.
Re: Add collapsible sections to "new" dashboard pages like the "old" standard pages
Bump this as well
Re: Add collapsible sections to "new" dashboard pages like the "old" standard pages
Bumping - great idea, would greatly improve the way we navigate through dashboards.
Ritwik
Re: Calculate Age Using DOB and Interaction Date
FLOOR(DATEDIFF(date of interaction, date of birth ) / 365.25)
Floor rounds down since age is usually expressed as the completed integer and never rounded up.
365.25 to account for leap years.
jroach
Re: Sum Values based on duplicate unique values in another column
From your original data table, you could try something like this:
sum(sum(DISTINCT Amount) fixed (by Member,OpptyID))
that gives me this
Re: Counting nulls/blank cells in beast mode
If your value isn't null but empty or blank, you might need to consider a different option. Another option would be check the length of the value of the field and also use the sum operation. Like this:
SUM(CASE WHEN LEN(TRIM(columnname)) >= 1 THEN 0 ELSE 1 END)
This will trim out any spaces and then check the number of characters. If the length is at least one, apply 0. Otherwise, apply 1 and then sum.




