Tickets last updated more than 48 hours ago

[mchandler]

Good afternoon all, 

I am a little stumped. I am trying to display the number of tickets that have not been updated in the last 48 hours. My roadblock

 

is when I try to use the relative time filter on the report builder screen. I just learned there is not a filter for "not in the last X"

So I guess I need to build this in a measure then filter based on the other items. This is where I am having the issue. I cannot figure out how to build this measure.

The [Last Updated Date] is a format of mm/dd/yyyy 11:59:59 AM

The other items are "Agent Group" and "Status". My visual is a card that will tell me the number of Partner Support Tickets that have not been updated in the last 48 hours. 

Anyone have a suggestion?

[TheoC · Accepted solution]

Hi @mchandler 

Give this a quick try as a Calculated Column:

Check = 

VAR _MaxDate = MAX ( tblDateTime[Value] )
VAR _MaxLess48 = _MaxDate - 2

RETURN 

IF ( tblDateTime[Value] <= _MaxLess48 , 1 , 0 )

It will return a 1 for everything greater than 2 days old and a 0 for anything prior to that.  You should be able to drag the column across into the Filter pane and remove the "0".

Hope this helps 🙂

Theo