Forum Discussion
Report ticket line chart
Hello,
I have an issue with à ticketing flow.
I want to create Three Measure with this result (see Excel attached)
Can you help me ?
| ID | ID_revision | Status | ModificationDate |
| 1 | 1 | A | 01.01.2018 |
| 1 | 2 | B | 01.01.2018 |
| 2 | 1 | B | 01.01.2018 |
| 2 | 2 | C | 02.01.2018 |
| 3 | 1 | B | 02.01.2018 |
| 4 | 1 | A | 02.01.2018 |
| 4 | 2 | B | 03.01.2018 |
| 4 | 3 | C | 03.01.2018 |
| 1 | 3 | C | 03.01.2018 |
| 5 | 1 | A | 04.01.2018 |
Thanks
1 Reply
v-lili6-msftCommunity Support
hi, Anonymous
What is the logic of these three measure?
Just from the excel screenshot, It’s difficult to understand the logic of your expected output.
Could you please explain the logic with your sample data?
Regards,
Lin