1 of 1 people found this helpful
Is there a reason why you have the data structured in the format above? Can you change the data structure like this....
Reason Code Time Test A 10 Test B 33
With that, I think we might be able to achieve part of the visualization you have requested... How about the attached?
thanks for your answer. I wish I could changed the structure.
Unfortunately, the extract I'm working on produce a report where each record can have multiple reasons for delay, therefore it is created in the system as Code 1 / Code 2... (actually up to 4), all being on one line.
Thanks to your work, I'm getting into something very similar to what I'm looking at.
I made a workaround on the result by showing only sum of each record and a breakdown of the code.
Here is my problem though, as you can see if there is more than one code, this will be replicated into the next bar.
Does anyone know a way to make the labels conditional ? (i.e. C1 in the first bar, C2 in the second...)
Thanks in advance.
Delay_Test.twbx.zip 36.3 KB