Data Exploration & Discovery- Visual Analyzer Projects

Question

Summary

Content

Hi team,

I am using oracle Visual Analyzer for creating some reports. But, I have an issue while applying one condition in a particular column to avoid the decimal values.

-10.00 ( Can you please help me with steps to change value to decimal level in a column)

Data column: I want to change date format YYYY-MM-DD. PFA the current output.

Thanks,

Venkata Kolla.

Syedsalmancs110 · Answer

Hi Venkata,

If suggested steps helped you achieve your requirement then request you to close this thread as currently it is unanswered.

If above steps didn't help then please post back the steps you followed to resolve the issue and then close the thread!!:)

Thanks

Syedsalmancs110 · Answer

Hello Venkata,

1)

>> Right click on the column with decimal values--> In the list of options select "Properties..."

>> Go to tab "#"(Value) --> change "Decimal" parameter value to "none"

2)

>> To calculate Date in YYYY-MM-DD format using date column you can make use of "Add Calculation"  at the bottom of the Project

>> You can make use of Evaluate function as shown below to get desired format, and make use of new calculation column in your project instead of actual date column

Thanks and Regards,

Syed Hamd Salman