Backlog tickets

[Anonymous]

Hi

I am creating dashboard for our department ,

I want to present the backlog tickets in 2 different chart .

1st chart : tickets the created  < 4 days   - for this chart I did it using filter pane

2nd chart : ticket the created   >= 4 days   -  need your support 😊

pbix file in below link

https://drive.google.com/file/d/16V5VjACKXAJHL7IzLj9R9WKfnsPxfcM4/view?usp=sharing 

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

In your sample , I found that 1st chart :tickets the created <4 days , you are using a relative date filter pane to achieve it.

In fact ,you can create a calculated  column 'Today-SubmitDate' :

Today-SubmitDate = DATEDIFF(Sheet1[Submit Date],TODAY(),DAY)

Then apply 'Today-SubmitDate' to filter pane  to filter this visual as below:

1st chart : tickets the created  < 10 days  :

2nd chart : ticket the created   >= 10 days

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

Hi @Anonymous ,

You can create a table or matrix with the two categories:

1) <4 days

2) >=4 days

Now create two measures to get the corresponding values. The code would look something like below:

1) For <4:

DelayedTickets = 
VAR TimeFrame = 4
VAR backlog =
    COUNTROWS (
        FILTER (
            'YourTable',
            IF ( 'YourTable'[YourColumn]
                 < TimeFrame,
                1,
                0
            )
        )
    )
RETURN
    backlog

Similarly for >=4 days

I hope this will suffice your requirement