Best Of
Re: Change a Dataset and Replace All Downstream Processes With It?
I feel like there might be a way to force the dataset ID to match the ID that the WB was using. If you did that and deleted the WB dataset, would that work? Kind of theory crafting here... but I thought the other ETLs, etc. pulled the dataset in by looking at the dataset ID. So, as long as your replacement dataset had the same dataset ID, wouldn't that work?
Re: Calculating Headcount based on Labor Hour Report
Hi @gbrown try using COUNT(DISTINCT(`employee name`)) in a beast mode to count the number of unique employees.
Re: Color Rules based on column not used in chart
@newbee You can use a beast mode to create the column. Something like:
case when CURDATE() <= 'DateField' then 'Actuals' else 'Forecast' end
This is just an example and depending on your data, you may have some other way of determining what is Actuals and what is Forecast. Then you just use that beast mode to set your color rules.
Re: Color Rules based on column not used in chart
@newbee - You would want to make the field that contains the "Actual / forecast" status your series. Then I would take whatever you currently have as your series and make it a quick filter. However, this will only let you view a single line at a time. That being said, I'm not sure how one is supposed to understand the above graph if all of the actuals became the same color and all of the forecasts did as well. You would really need to aggregate them to a single line anyway, right?
Re: Copy an entire dashboard
@damen Yes, if you click the wrench in the top right corner of the dashboard and select "Save As" you can copy an existing dashboard.
Re: Card Status Data in DomoStats or DomoGovernance
I did a python implementation of solving this here: https://www.youtube.com/watch?v=3ZwlzOlRBbA
Re: Return most recent row/date
@AdamC You can use a Rank & Window tile:
https://domohelp.domo.com/hc/en-us/articles/360042922814-Old-Magic-ETL-Tiles-Rank-and-Window
Using Row Number as the function, then ordering by EVENTTIME descending, and partitioning by EQUIPMENT_NUMBER. This new column that's created will assign the most recent date for each equipment number a value of 1 and you can just filter to only allow where the row number is 1.
Re: Return most recent row/date
@AdamC You should be able to accomplish this with the Rank & Window tile using a Rank function, ordered by EVENTTIME (descending), and partitioned by EQUIPMENT_NUMBER. This will return the most recent event for each piece of equipment with a rank of 1.
https://domohelp.domo.com/hc/en-us/articles/360044876094-Magic-ETL-Tiles-Aggregate#4.1.