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.
Re: Beast Mode
You need a few helper columns to acheive this. The first is the ID, the second is the revision number. assuming the revision number is in chronological order (highest number being the one you want to count) then you can add another column that finds the maximum revision number by ID. Lastly, create a function that reads the maximum revision number and the actual revision number, and produces a 0 if it is not the maximum, and a 1 if it is the maximum. Filter off anything that is not equal to the maximum id revision, then count distinct ID values.
This can be done in magic ETL and in Beastmode.
beast mode for finding the maximum revision number by id: max(`revision_number`) over(`id`)
beast mode for determining if the current revision number is equal to the max: case when `revision_number` = max(`revision_number`) over(`id`) then 1 else 0
filter off anything that is a 0 in your card
beastmode to count distinct IDs: count(distinct `id`)
This is just one of many ways to solve the problem.
nmizzell