Narrow query from SPO list to last 24 hours

[arevach]

Hi,

I connected to a list in SharePoint Online (that has a few lookup values to other lists). I wamt to create a report (Table or Matrix visualization) to show only the last 24 hours (Yesterdays 8AM to today's 8AM). how and where do i put this cretiria? 

Thanks a lot in advance,

Assaf

[v-jiascu-msft]

Hi @arevach,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft]

Hi Assaf,

Do you have a DateTime type column?

I would suggest you import the data then add the DateTime type column in a Sclier which will be set to an interval of 24 hours. 

Can you share a sample?

Best Regards,

Dale

[arevach]

Hi Dale,

Thanks for the response.

I have a SPO list with Date type column Report Date. 

I would like to send a scheduled report to bunch of users of the last 24 hours , AKA Report Date Between Today and Yesterday...

I've added a filter visualization but do i set it on today or yesterday so i will be able to acheive the report of last 24 hours?

What sample do you need? 

Assaf

[v-jiascu-msft · Accepted solution]

Hi Assaf,

The workaround could be adding a custom column like below. Then you only need to filter the 1 or 0.

IfLast24 =
IF (
    (
        DATEVALUE ( [Column1] ) = TODAY ()
            && TIMEVALUE ( [Column1] ) <= TIME ( 8, 0, 0 )
    )
        || (
            DATEVALUE ( [Column1] )
                = TODAY () - 1
                && TIMEVALUE ( [Column1] ) >= TIME ( 8, 0, 0 )
        ),
    1,
    0
)

Best Regards,

Dale