Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Dashboard - hid if value = 0

Received Response
1
Views
1
Comments
TKQ5Q
TKQ5Q Rank 3 - Community Apprentice
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi all

I am trying out the dashboard using Enterprise Edition 11.1.1.7.

I encountered the following problems and hope you can help me.

1) I have a visual with value = 0, how to I filter them?

The X Axis are product name, is there a way to filter away those value = 0?

2) I have a table column in the visual which the number are in decimal, but these are actually whole number (number of product sold)

Is there a way to change the number format?

Thank you for your help.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    As said in your other thread, a dashboard doesn't have any content. It only has links to analysis and display a view of that analysis based on the settings you define.

    You want to change these things? Edit the analysis that are doing the real work of retrieving data and add a filter there to remove results if 0 and change data type formats for the columns you need there in the analysis.