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,

Hi @User_RD03L, Can you please try the following to see if there's any betterment? 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…

Hi @Vinoth Mounagurusamy, You can define the column as String and then just take the 'YYYY-MM-DD' part with the help of Substring function and then again cast it to Date. CAST(SUBSTRING(CAST("- General Information"."Invoice Entered Date" AS char) FROM 1 FOR 10) AS DATE) It should only bring the Date part after download…

Thank you very much @Gaurav Bharadwaj-Oracle! Very useful information. Cheers,

Hi @Vinoth Mounagurusamy, I think you need to see the data in 'Data Time Zone'. Can you please check the attached XML / Catalog and filter with your invoice and see which column is giving you the correct data also match back the data with your application data. Ideally in my experience 'Data Time Zone' should be the…

Hi @Vinoth Mounagurusamy, Are you using 'Data Format' tab to define the column as 'Date'? If yes, instead define the column as Date using Cast in the 'Column Formula'. It should not get the time part after download. CAST(Invoice Creation Date as DATE) Hope this help. Cheers,

Hi @Vinoth Mounagurusamy, If your requirement is to show only date part, you can easily achieve by defining the column as Date. Say the Column Name is 'Invoice Creation Date' so in the edit formula tab you have to define like: CAST(Invoice Creation Date as DATE) It'll only return the Date part. Hope this help. Cheers,

Hi @Steph Yeung, You can achieve it using Pivot Table. Place your 'Element Name' in the Column Section and 'Displayed Input Value' in Measure Section. Select some 'Aggregation Rule' for 'Displayed Input Value'. Please find below the screenshots. Pivot View Settings: Aggregation Rule: Table vs Pivot: Hope this help. Cheers,

Very helpful article. Thank you very much @Prasenjit_Thakur-Oracle!

It'll be a very helpful feature to have. Upvoted.