How to filter between yesterday at specific time and today

Hi!
I made a report which lists the ticket that are created yesterday and today, but I wanted to filter only the tickets that are created from yesterday at 4pm until today.

I used the following filter: Created date > yesterday at 4pm

However, it still shows all the tickets that were created yesterday regardless of time. See screenshot below:

I have highlighted the tickets that should not be included.

I have also tried the following filters but still, have the same results:
Created date > yesterday at 16:00
Created date > yesterday at 4:00PM
Created date > yesterday at 4:00 PM

Please advice.
Thank you.

Hi @Leo_Cagata,

When filtering rows by some date column, eazyBI can translate only the relative date part.

However, you may create a new calculated measure to filter issues by relative date and time. In the calculation, function DateBetween() can interpret the relative date and time to a valid timestamp.

The expression for calculated measure “Issue created since yesterday 4PM” might look like this:

CASE WHEN --check issue creation date between two relative dates
  DateBetween(
    [Measures].[Issue created date],
    "yesterday at 4PM", 
    "today")
THEN --if created recently then return measure
  [Measures].[Issues created]
END

Set measure formatting to Integer. More details on calculated measures are here: Calculated measures and members - eazyBI.

Now you can use the new calculated measure instead of “Issues created” and filter rows that has value > 0.

Best,
Zane / support@eazyBI.com

1 Like

Hi Zane,
Thank you very much! This calculated measure worked for me. :slightly_smiling_face:

1 Like