I have the data below and I would like to understand how to make a scatter plot with the X axis showing time (with the ability to cycle through hours & minutes) and the Y axis showing Time in MicroSeconds. I have millions of rows so I imagine I will see a lot of dots on my screen. Can anyone help? Below is my load script and attached is the sample data.
LOAD
date(date#(mid(@2 2, 20), 'DD/MMM/YYYY:hh:mm:ss'), 'DD/MMM/YYYY hh:mm:ss') as [Creation Date Time GMT],
date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm'), 'DD/MMM/YYYY hh:mm') as [Creation Date GMT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'MMM-DD')) as [Date PDT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'YYYY')) as [Year PDT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'MMM')) as [Month PDT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'DD')) as [Day PDT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'hh')) as [Hour PDT],
Timestamp#(date(date#(mid(@2, 2, 17), 'DD/MMM/YYYY:hh:mm')-Timestamp#(7,'hh'), 'mm')) as [Minute PDT],
