Please find the attached screenshot below to answer you question. Please find the attached for the same created using tableau 10.
Let me know if this solves your query.
Thanks and Regards,
Counting 2 or More breaks.twbx 39.6 KB
Thanks you very much for your fast feedback. I have no problem to show in/out moments on the gantt-chart. The case is to show it as a gantt-chart with something in the size like on the screenshot below:
I have counted datediff before first "In" and last "Out" in one day. I can visualize it but I don't have any idea how to count from first "In" to the break (first "Out") and then from second "In" to second "Out" etc. and how to use it as a size to grate real gantt-bar.
Have you got any idea without any preparation in the source file? If I prepare file like: Date | Type (in/out) | time start | time end there is no problem to count it and viz. But I can't change the input files unfortunately.
I will be glad for any help guys!