Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Needs Votes
312
Views
5
Comments
Partha P Pramanik
Partha P Pramanik Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server Idea Lab

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.

7
Up
7 votes

Needs Votes · Last Updated

Comments

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    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
    Partha P Pramanik Rank 2 - Community Beginner

    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
    Avinash Krishnaram-Oracle Mod
    edited May 16, 2025 5:06PM

    Have you tried the IfNull function in Calc?

    image.png
  • Partha P Pramanik
    Partha P Pramanik Rank 2 - Community Beginner

    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
    Mohaideen Rank 1 - Community Starter

    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