Hello Tableau experts,
I really need some help please! I have a sample data set on horse betting in the table below which I'm trying to analyze
The data set has a fictitious customer name, Horse, Date and Time of transaction. I would like to use Tableau to calculate the fields in bold and I have provided the answers I'm expecting.
- What is the number of days between the last and the previous transaction (Days_Diff)?
- What is the Time Diff (seconds) between the last and previous transaction?
- How many transactions has the specific customer executed in the last minute (COUNT_1 min), 5 mins (COUNT_5 min) and 24 hrs (COUNT_24 hrs), respectively.?
- How many different horses has the specific customer placed bet on, in the last 24 hrs (COUNT_horses 24 hrs)?
I will so much appreciate your help with this! I'm using Tableau 10.2
|ID||Name||Horse||Date||Time (hh:mm:ss)||Days Diff, if not same day||Time diff (seconds), if same day||COUNT_1 min||COUNT_5 min||COUNT_24 hrs||COUNT_Horses 24 hrs|
Thank you very much in advance,
Message was edited by: Eze Nwa Thanks Tom, I have just uploaded a packaged workbook indicating what I'm trying to do. Thank you very much! Eze
Test_Data set_EN.twbx 70.3 KB