-
1. Re: TimeLine Graph in Tableau
Shinichiro MurakamiDec 18, 2016 9:23 PM (in response to ahmad.awad)
Hi Ahmad
You can draw this type of chart by "Gantt", and that needs start point info and duration as "size".
In this case, you need to specify, event Name(or ID) and Start/End.
If you can do that in original data source, that's the best.
<== Actually I realized later you have event ID, you can use ID instead of name, But because excel did not have ID column, I created this one.
Time Event Start / End Event Name 8:00 AM Device Started Start Device 8:05 AM Quality Check Started Start Quality Check 8:09 AM Quality Check End End Quality Check 8:15 AM Antivirus Program Started Start Antivirus Program 8:20 AM Custom Scan For Virus in C Drive Started Start Custom Scan For Virus in C Drive 8:25 AM start cleaning virus $54Gop Start cleaning virus $54Gop 8:26 AM start cleaning virus ZXrr009i Start cleaning virus ZXrr009i 8:30 AM Custom Scan For Virus in C Drive End End Custom Scan For Virus in C Drive 8:35 AM end cleaning virus ZXrr009i End cleaning virus ZXrr009i 9:00 AM end cleaning virus $54Gop End cleaning virus $54Gop If not, in Tableau, the conversion formula looks like below based on given info.
[Start or End]
if contains([Event],"start") or contains([Event],"Started") then "Start"
elseif contains([Event],"end") or contains([Event],"Ended") then "End" end
Then, need to re-calculate start and end time respectively.
[Event Name] <== Actually I realized later you have event ID, you can use ID instead of name, But because excel did not have ID column, I created this one.
replace(replace(replace(replace(replace([Event],"end ",""),"End",""),"started",""),"start ",""),"Start","")
[Time Start]
if [Start or End]="Start" then [Time] end
[Time End]
if [Start or End]="End" then [Time] end
Then Time duration for each [Event Name]
[Time duration]
{fixed [Event Name]:min(if [Start or End]="End" then [Time] end)}
-
{fixed [Event Name]:min(if [Start or End]="Start" then [Time] end)}
Thanks,
Shin
-
Gantt_Bar_SM_9.2.twbx 21.5 KB
-
-
2. Re: TimeLine Graph in Tableau
Mahfooj Khan Dec 18, 2016 9:37 PM (in response to ahmad.awad)3 of 3 people found this helpfulHi Awad,
Yeah this can be done in tableau. Connect your data in tableau and drag your field like that,
Note: format your time field to h:nn AMPM and make to continuous
Let me know If this help.
Mahfooj