I am not sure if this is the right thing for what I am trying to do, but I have data in this formate
source dt value X 2018-03-06 11:00 0.31 X 2018-03-06 12:00 0.94 X 2018-03-06 13:00 0.89 X 2018-03-06 14:00 0.01 X 2018-03-06 15:00 0.43 Y 2018-03-06 11:00 1.43 Y 2018-03-06 12:00 0.50 Y 2018-03-06 13:00 0.10 Y 2018-03-06 14:00 0.42 Y 2018-03-06 15:00 0.41 Z 2018-03-06 11:00 5.34 Z 2018-03-06 12:00 4.32 Z 2018-03-06 13:00 4.20 Z 2018-03-06 14:00 0.89 Z 2018-03-06 15:00 0.01 I'd like to graph it as three lines (X, Y and Z) over time, so the graph tool I am using asks for it this format: dt X Y Z 2018-03-06 11:00 0.31 1.43 5.34 2018-03-06 12:00 0.94 0.50 4.32 2018-03-06 13:00 0.89 0.10 4.20 2018-03-06 14:00 0.01 0.42 0.89 2018-03-06 15:00 0.43 0.41 0.01 So I think that would be a PIVOT like function right (which I don't think Drill has) Is there a way to "fake" this in Drill using some other built in functions? Thanks! John
