Oracle Analytics and AI

Display rows with NULL values as 0 to help sorting the pivot data in data visualization in OAC

There is currently no option in OAC Data Visualization to display null values as 0. In Oracle Analytics Classic however there is a solution for the same as described in the link below:

https://community.oracle.com/products/oracleanalytics/discussion/19049/display-rows-with-null-values-in-data-visualization-for-oac-oas

However there is no such solution in DV. This makes the sorting of the data in a pivot visualization very difficult for any user as the null rows always appear at the top. The users have to keep scrolling down until the data appears, this hampers their productivity.

Please look into this and enable this feature in DV.

Thanks

Partha.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Gabby Rubin-Oracle

The Workaround is to create a calc that replaces Null with zeros.

We are looking into the Null at the top of the sort issue.

Partha P Pramanik

Hi Gabby

Thanks for your reply. Could you please elaborate how to use a calc here? I guess the idea would be cast the concerned value column in this data format: #,##0;-#,##0;0

I am not sure how to though. Appreciate your help.

Avinash Krishnaram-Oracle

Have you tried the IfNull function in Calc?

Partha P Pramanik

Hello Avinash

I tried the same, but it does not work in my case.

In my dv, I am showing the no of orders for different product divisions by customers. So if a certain cutsomer does not have any order for a one of the product divisions, it will have null for that, however the other product divisions have value. The issue is when users want to sort by the number of order for one given product divisions, the ones with null come at the top. Trying to find a way to avoid this situation.

I did raise a service request, but was encouraged to put it here instead as the feature is not available yet.

Thanks

Partha.

Mohaideen

Hi Partha,

Please try with the below steps whether it works.

Create a dummy column with following formula ifnull(division, 'zzzz')

Hide dummy column and sort your visualization based on the order you expect.

Regards,

Mohaideen