Forum Discussion
Count values from date
Hello guys,
I have a data set here that's like this:
| ID | Opening Data | Closing Date |
| 1 | 03/06/2018 | 03/06/2018 |
| 2 | 03/06/2018 | 04/06/2018 |
| 3 | 04/06/2018 | 05/06/2018 |
| 4 | 05/06/2018 | 05/06/2018 |
| 5 | 05/06/2018 | 05/06/2018 |
| 6 | 06/06/2018 | 06/06/2018 |
| 7 | 06/06/2018 | 06/06/2018 |
| 8 | 07/06/2018 | 08/06/2018 |
| 9 | 07/06/2018 | 08/06/2018 |
| 10 | 09/06/2018 | 10/06/2018 |
What I need to do is, use a graph to represent the number of opening and closed tickets by day. So let's say I drag opening date field to my X axis, when I try to do the count on the date rows, I get wrong values for the closing date.
Can anyone help me with that?
Thanks!
Hi,
I believe this is the result you want. You may download my PBI file from here. I edited the closing date for ID 9 to June 12.
Hope this helps.
8 Replies
Hi,
If an ID opened on Jul 1, 2018 and closed on Jul 5, 2018, then i understand the opening and closing dates. But what about the dates in between? How should the dates from Jul 2-4 be treated?
Show your expected result in a Table. Once the table is ready, one can simply switch the result to a graph.