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…

Hi, @Sumanth V -Oracle , I have tried to use the calculation that you sent however it seems it still considers the weekend and it should 24 hours only

Hi, @Sumanth V -Oracle , thank you for your response, however my goal is not to consider the weekends or exclude the weekends, specifically Saturday and Sunday. Thank you!

No problem. Here's my linkedin profile. Thanks Bharat! https://www.linkedin.com/in/joven-de-luna-204132a5/

Hi, @Bharat Agrawal have you check on it? Looking forward to positive response. Thank you! I appreciate your help.

I tried the said calculation however the result is 0 which should not be.

Hi, @Bharat Agrawal I checked and 2 is returning as well, and 2 is the right one. I'm trying to filter the 'Actual Spend Amount' within a calculation to compute the Comparable Spend only, however I'm having this error, and I think the Filter function doesn't work on aggregation. Can you help? Thanks a lot!

Hi, @Bharat Agrawal , when I tried this, the result is only "Yes' which should not be.

Hi, @Bharat Agrawal thanks for your quick response. that result no error. however I want to have a filter that will show only comparable parts.

Hi, @Bharat Agrawal can you me help on this?

Hi, @Mallikarjuna Kuppauru-Oracle I haven't tried the time-series Functions and no idea on how can incorporate that. Can you help?

Thanks @Bharat Agrawal , however I am having this syntax error. Is there a way to add case when expression, that when Part Numbers in Fiscal Year 2024 is present also in Fiscal Year 2023 then 'YES' else 'NO'