I have a report that has asset names in the rows and binary values in the columns for utilization per hour. Each column header is a date and time string, e.g. “2/20/2011 22:00”.
I am trying to derive a report that can give me daily utilization % of each of these assets for a 3 month period. Would appreciate any help. Tried using “ExtractTimeDate” function but it seems only good for a single asset utilization. Look forward to your suggestions/recommendations.
attached an example workflow.
I guess it could be done more refined - but it works
Basically I go a few transposes to remove the time from the timestamp + do the group by.
Afterwards I rearrange the sums to the original table.
Any recommendations on how that could be done using the above output you have specified. I tried transposing the data but in either way, the column headers will not become filters while pivoting it out. Below is the type of pivot I would like to create from this data. Even better if there is a way to visualize as well, using KNIME.