Best Of
Re: Heatmap in 30 Minute Intervals
You could do something like:
CONCAT(HOUR(`Timestamp`), ':', FLOOR(MINUTE(`Timestamp`)/30)*30)
Minute will return the number of minutes in the timestamp (0-59)
/30 will return a number between 0 and < 2
FLOOR will convert your fraction to 0 or 1.
*30 will convert the interval to either 0 or 30. This will then give you your half-hour buckets.
You may need to extract the hour and minute to separate beast modes in order to sort based on the hour and then the 30 minute bucket so that it's sorted properly.
Re: Compare one column to another then out other data.
You'll need to utilize a Magic ETL for this. You can take the dataset as your input. Then feed it to a Select Column Tile. You can then select the Supervisor Name and the Email columns where you rename the Email Column to 'Supervisor Email'. Then feed your original dataset into a Join tile where you will left join your data with the output of the Select Columns tile where the Supervisor Name = Supervisor Name. This will then add in a new Supervisor Email (which we named in the prior steps) and should then have the supervisor email for every other employee.
Color rules in Domo Phoenix
Hi all, I am using the DDX Phoenix Scatter Plots App and wanted to apply some color rules like you do in a regular card in Analyzer.
I was looking at the documentation but it is only shown how to change the color palette, not how to apply color rules (ex: if Metric < 1 then red else green). Do you have any suggestion?
Thanks
Fatias
Re: DataSet List View - Display # of Dataflows Using it as a Source
It would be great if there was an option to export the data lineage from a starting dataset. Lineage levels would be great too.
