Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I have a data set for a secondary market ticketing information application. There are several fields that I am trying to visualize. Specifically, the quantity of tickets posted in regards to an event date and a sample date.
For example, there is an event on 12/20/2014 (eventDate) and overall there have been 2500 tickets posted to the secondary market for this event (Quantity). Those 2500 tickets have been posted periodically to the secondary market over the past several months (Sample Date).
How can I create a visualization to show the number of tickets (Quantity) posted for an event (eventDate) over the course of time (Sample Date)
Thank you.
Use below script
Temp:
LOAD
TimeStamp(ALT(TimeStamp#(Date,'DD/MM/YYYY hh:mm'),Timestamp#(Date,'M/DD/YYYY h:mm:ss TT')))as DateTimeStamp,
Date(FLOOR(TimeStamp(ALT(TimeStamp#(Date,'DD/MM/YYYY hh:mm'),Timestamp#(Date,'M/DD/YYYY h:mm:ss TT'))))) as Date,
Opponent,
Section,
Row,
Price,
Quantity,
TimeStamp(ALT(TimeStamp#([Sample Date],'DD/MM/YYYY hh:mm'),Timestamp#([Sample Date],'M/DD/YYYY h:mm:ss TT')))as [Sample Date TimeStamp],
Date(FLOOR(TimeStamp(ALT(TimeStamp#([Sample Date],'DD/MM/YYYY hh:mm'),Timestamp#([Sample Date],'M/DD/YYYY h:mm:ss TT'))))) as [Sample Date],
Board,
ETicket
FROM YOURTABLENAME;
Now create pivot table with
Dimension
Date
Sample Date
Expression
SUM(Quantity)
thank you