Hi @Kundan Kumar17, Can you please try the following? Create a dashboard prompt with a 2 date columns and define a presentation variable for each of them. Like: pvToDate & pvFmDate. You can use any default value if required as it is optional. Now use those 2 variables in your Data Model Query. i.e.: trunc(HIRE_DATE)…

Hi @Kundan Kumar17, Can you please share some screenshot detailing the issue you are getting or the requirement that you have. It'll help us to understand your specific problem and will enable us to work on any work around / solution etc. Cheers,

Hi @Controlcard, Can you please check the following and see if there's any betterment? Have you done 'Allocated Checklist.Checklist Name' as 'is prompted' in your analysis 'BOTestTableView'? Have you pressed the button 'Apply' after selecting the prompt value from the 'left dropdown'? Hope this help. Cheers,

Much needed feature and will add so much values to the existing products. Upvoted.

Thank you very much @SteveF-Oracle! Much appreciated all your help.

Very helpful information. Thank you very much @Mostafa Morsy-Oracle & @SteveF-Oracle!

Much needed feature and it'll add so much values to the existing product. Upvoted.

Much needed feature. It'll add so much values. Upvoted.

Very informative & very helpful information. Thank you very much @Sushil Dhoot-Oracle! Much appreciated all your kind help. Cheers,

Hi @Sulakshana Sridharan-Oracle, If possible, please include me too. Thanks for all your help. Cheers,

Wow, it's truly professional & awesome data vizs.

Hi @User_X33RN, Please find below the Best practices that need to be considered while developing a report using more than one subject areas. You should have common dimension in the subject areas used in the report. Add at least one Measure/Fact/Metric from each subject area on the report. Click on the Advance tab of the…

What issues are you getting after following the post that Mandeep has kindly shared @Kundan Kumar17?

Hi @Techie, What is your issue / requirement? Can you please provide the details so that it can be looked accordingly. Cheers,

Merry Christmas & Happy Holidays Everyone. All the Best.

Can you set the aggregation rule as per the below screenshot for the pivot table? select 'Max' instead of 'Default'. Can you also check your data in 'Table' View with the latest formula that I provided.

Can you please see the data in a table view instead of Pivot Table and send us a screenshot. Actually any measure that you are using in pivot view need to have a specific aggregation. If possible attach your report catalog or xml here. Cheers,

What aggregation type have you selected for Hours?

Hi @User_RD03L, Please try the following: CASE WHEN ("Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday IN' AND "Reported Time Cards"."Reported Hours" IS NOT NULL) THEN CAST("Reported Time Cards"."Reported Hours" AS CHAR) WHEN ("Reported Time Entry Details"."Payroll Time Type Name" = 'Public Holiday…

Hi @User_RD03L, Can you please add "Reported Time Entry Details"."Payroll Time Type Name" in the above report and send the screenshot as suggested by @gclampitt , it will help to understand the data points and will be helpful to code accordingly. Cheers,