How would a new column be generated in the analysis result

Question

How would a new column be generated in the analysis result that would be based on two other existing columns/prompted input (i.e calculating number of days between effective start date and effective end date and then recording the difference as number of days in the new column)?

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28261/how-would-a-new-column-be-generated-in-the-analysis-result

Hi @User_M2U6X,

You can easily achieve it using a calculated column.

Here's an example for you where 'Age in Post in Years' has been calculated using start date & today's date.

Please find below the Report XML that you can use as a starting point and might be useful for the understanding.

XML - Calculated Column.txt

Hope this help.

Thank you.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/28261/how-would-a-new-column-be-generated-in-the-analysis-result

Welcome to Oracle Analytics and AI community.

Please check below threads:

OTBI Performance Tile Filter : How to get difference between 2 dates — Cloud Customer Connect

How to calculate difference between two dates in OBI? — Cloud Customer Connect

Thanks.