Hi,
I need to calculate column "start time" as provided in excel in tableau.
Also, I need to calculate start time of 80% of the requests based on the second tab of excel file.
Please find the sample data, reference pivot image and desired output image.
Can someone please help me on this?
Thank you
@Gauri Agarwal I am sure there must be a better way of showing this but check my initial thoughts on the above request. You need to load the data and create a running total expression like below:
RUNNING_SUM(COUNT([Request start time (copy)]))/10
Before that try to duplicate your date field to show just the dates removing timestamp by adding Date(yourdatefield)
And to show only time like (hh:mm) just click on the date - default properties - Format - Custom then type in hh:mm like below:
Create a Rank to get the first 80% like below:
RANK_UNIQUE([RunningTotal])
Final output:
Attached .twbx file for reference. Let me know if any questions.
