Oracle Analytics Cloud and Server Idea Lab

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

Changing the data format through conditional formatting in DV

Needs Votes
51
Views
1
Comments
Danish DP World
Danish DP World Rank 3 - Community Apprentice

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

DP World

Description (Required):

I've created a report in Classic home and apply condition formatting on non-measure column (Ordering Column).

For E.g:

If ordering in (41;43) then Data Format should be in number with 0 decimal places when ordering in 32 then Data Format is custom like #,#0.00,,.

How to apply Same conditional formatting in DV ?

Use Case and Business Need (Required):


Enhancement Request / Service Request: 3-30351290161

4
4 votes

Needs Votes · Last Updated

Comments

  • Patrick Borcik
    Patrick Borcik Rank 3 - Community Apprentice

    This would be very helpful especially when you have multiple metrics with some being numbers and some being %. The only way I found to do this was to duplicate the visualization and then use freeform to put the duplicates on top of each other. Then you can use the visibility parameter to hide each one depending on the format needed. This makes maintenance very ugly.