Hi, @Mallikarjuna Kuppauru-Oracle my problem is how to set up the percentage bucket

Hello @Mallikarjuna Kuppauru-Oracle . Thanks for your response. I am aiming to have something like this: So the spend and the # of parts result per % bucket will adjust based on the 'Parts Analysis View' selected

Hello, @Richard Kemp-Eyre! Thank you for your response. I tried the calculation you have sent but I'm having an error.

Hi, @Sumanth V -Oracle I don't want to use the date range filter because I am planning to create a table with the columns Last 12 months, Last 3 months and Last 1 month. Using date range filter in a table will give me the same result for all columns.

Hello, @Mallikarjuna Kuppauru-Oracle Thank for your response. this the value I am getting based on the expression filter I have. The earliest is 12/11/2022 and my aim is to be 12/01/2022 and the latest is 12/04/2023 which should be to 11/30/2023 only. I should exclude the latest/max month which for this one is December…

Thanks @JoseP-Oracle ! How about the grand total? I need to create a tile visualization of the sum of the 'Base Spend 2 SUMMARY'. On your example, I need to total 23, 34 and 46 having a total of 103.

Thank you @JoseP-Oracle !!! It worked.

Hi, @JoseP-Oracle . Thank you for your response; however, it's giving me single digits for months and days from 1 to 9 even though we have set CHAR(2) I may have a problem with sorting.

Thank you for your help @Raghavendra Raghunath-Oracle !!!

It worked. Thank you @Raghavendra Raghunath-Oracle !

how can I go to that Developer tool/Query Log option in OAC?

@Prasad Kolli-Oracle can you give me a sample logical SQL query? Sorry I'm just new to it. And is it possible to MAX date, not current date, because there maybe some situation that current date may not be available yet. Thanks!