Forum Discussion
Need help with data modelling
Hi friends, Another problem: I have a service contract with 3 types of calls (Normal, Urgent, Very Urgent) Furthermore, each call has 5 different 'stages' and depending on the call priority t...
Hello Ruslan,
Below you find an example of the dataset without any formatting. Is this enough info for you?
Kind regards, Sander
Call number | Priority | Acceptation time | Response time | Secure time | Restore time | Resolve time |
| Call 1 | Urgent | 01:19:21 | 01:19:21 | 13:59:05 | 13:59:05 | 13:59:05 |
Call 2 | Very Urgent | 00:16:08 | 01:07:49 | 07:13:18 | 07:13:18 | 07:13:18 |
| Call 3 | Normal | 00:09:13 | 18:51:33 | 22:03:22 | 22:03:22 | 22:03:22 |
Hi Anonymous ,
I'd like to suggest you use 'unpivot column' on your time fields to convert them to attribute and value, then you can simply use visual level filter to control what type of DateTime display on your visual.
Regards,
Xiaoxin Sheng