Best Of

Re: how to the find difference between dates ( in days ) that are in one column?

can you try:

DATEDIFF(`Transaction Date`,LAG(`Transaction Date`,1) OVER (PARTITION BY `Customer ID` ORDER BY `Transaction Date`))

I'm not sure if LAG() works in beastmode or not

ST_Superman

3

Re: Compare two peer groups

@Billobi can you expand on this concept a little bit more. I've been tinkering and I'm running into an issue where, even with fixed functions, if because Campaign1 and Campaign2 don't share at least one common row the chart bombs out.

This is the dummy dataset I made

Gave myself a lot of options for summing.

G_Grey

1

Re: Removing Duplication and Ordering Objects within a Concatonated Field

@n____l____ Do you have a list of all possible products that could appear in the list? If so, you could use a formula tile in ETL to create a column to check whether each product is listed. For example, the column to check whether Student Information System is in the list would look like this:

case when `Corporate Product Lines Owned` like '%Student Information System%' then 'Student Information System' end

Then you can re-concatenate all the new columns in the desired order without duplication.

MichelleH

2

Re: Removing Duplication and Ordering Objects within a Concatonated Field

@n____l____ Removing the "end" after your concat function should resolve the syntax error. If the nulls are still an issue, then you may need to update your 19 columns to show an empty string instead of null like this:

case
when `Corporate Product Lines Owned` like '%Student Information System%' then 'Student Information System'
else ''
end

MichelleH

2

Re: Holidays between two dates

Since you can't do conditional joins within Magic ETL 2.0 what you can do is add a constant to both datasets in your ETL and call it Join Column with a value of 1. Then do a join on both datasets on the join column. Then feed that into a filter tile to filter where company_holiday_date is BETWEEN your date_start and date_end. Then you can do a group by and count the number of records you have, joining that metric back to your original dataset A based on the start and end dates to record the number of holidays between the two dates.

GrantSmith

2

Re: DOMO Display Name reverting back

@WorldWarHulk do you know if your instance has SSO enabled? If so, it could be reverting back based on what is in your active directory system used for SSO.

The user may also be changing it.

Ashleigh

2