-
Re: How can I change a cell that has not data to say "none?"
case when `Credit Type 2` is null then 'none' else `Credit Type 2` end enter this formula into a formula tile in magic etl. this can also be done in a beastmode.1 -
Re: Beast Mode
Hey TMonty, You will need to create a conditional column: case when `timestamp` = max(`timestamp`) over() then 'Yes' else 'No' end However, this will require that you have a timestamp column. If you …1 -
Re: Governance Toolkit
Dataset Backup - I haven't found a need to use this. Domo has version history where you can restore previous versions of datasets / etls. I guess you could get some use out of dataset backup if the v…2 -
Re: Average time to response but how do I not include weekends?
Hey Deona, Break this calculation down into steps: Creation of ticket date First response date Days between creation and first response date Weekend days between creation and first response date Week…2 -
Re: Can I filter by latest date?
@damen, This can be accomplished with the rank and filter tiles. Simply rank the dataset by date descending and keep only rank #1 in your filter tile.2