Thanks @Jestin Rajan !!! It worked

Hi, @Nehemias-Oracle , thanks for your response. however the link is redirecting me to this one

Merry Christmas and Happy Holidays everyone! Maligayang Pasko from the Philippines!

This looks fantastic!

I’m onboard and have invited several others.

Thanks @Bret Grinslade - Oracle Analytics-Oracle ! Actually I already tried that workaround and it worked, however for the consumer side they don't have the capability to have auto suggested column, for example if they type MyDimension or other columns, that will not work for them unless I give the whole location path…

Sharing our best practice :)

How I wish I can receive mine. :)

I have this bucketing of PR to PO Cycle time and currently this considers the weekends and my goal is to exclude the weekends in the calculation: Case when ((TIMESTAMPDIFF(SQL_TSI_HOUR,"Procurement - Purchase Orders"."Requisition Lines"."DW_FA_X_REQ_LINE_TIMESTAMPS_LASTAPPROVALDATE","Procurement - Purchase…

Hi, @RichardChan. Thanks for your response however it seems like the calculation post some errors. I have tried this calculation and it works, (timestampdiff(SQL_TSI_DAY, (DATE '2024-03-06'), (DATE '2024-03-11'))) / 7.0 * 5.0 the result is correct as 4 days but when I tried to make the first date as Monday and the last…