1 of 1 people found this helpful
Wim, to answer your first question, generally Tableau likes data to be tall & narrow (as opposed to wide). You can get pretty close to you screen shot by using a Gantt chart:
I've attached both the file and spreadsheet. Hope this helps.
This is indeed a way to do the trick, unfortunately this would require a sample every minute and this would explode my data.. My data set only has the state changes as they occur.. (you get a mark on every event an the rest of the line stays blank)
I'll try to fit my data into your model and hope the database can handle the amount of data.
If you have any suggestion how to make it work with my setup, let me know.
Thanks again for your effort!
What do you mean when you say "you get a mark on every event an the rest of the line stays blank"? Do you mean there is null data in the data source?
@Tracy - one possibility is when using a Gantt chart, when there's nothing on the Size shelf then there's a mark drawn with no line coming from it, but I'm not sure.
@Shawn - I took your idea, reduced the data to just the status events and then added a table calc to compute the time from the current event to the next event.
@Wim - check out the attached, is something like this more what you're looking for?
Thanks Jonathan, that did the trick.
With the solution of Jonathan you can fill up the blank spaces.
@Jonathan: With your solution copied I got this result with some blank spaces:
Changing the formula slightly gave me the correct result: (change minute into second and multiply result *60)
Not sure what caused that problem..
Thanks anyway for your support! Things are working fine now.
I think the reason why the minute setting didn't work was a rounding issue, I'm glad you were able to figure it out!