Oracle Analytics Cloud and Server

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

alternating raw style for each view column

Received Response
41
Views
6
Comments
Calcioscacchi
Calcioscacchi Rank 3 - Community Apprentice

Hi there!

I have a view with 3 columns (alias 3 measures) and a certain number of rows. The number of rows depends on the value of another field, wich I choose from the prompt of my view.

Every column has a colour.

Now, look at the  "alternating style" of the analysis rows property. I know that this property is applied to all the columns in the same way. (look at the image: sorry if the screen referred to the italian version of OBIEE).

pastedImage_0.png

What i'm trying to reach is to build an alternating style of the rows but for each column:

  • if the first column is blue, I want the even raws in blue and the odds in a light blue.
  • if the second columns is red, I want the even raws in red and the odds in a light red.

and so on.

Do you know a way to reach this goal easily?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Looks like you're missing the image you wanted to upload

  • Calcioscacchi
    Calcioscacchi Rank 3 - Community Apprentice

    It didn't upload.

    Now you have the image

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok that's row highlighting that you marked there. You want columns. That means you need to colour the columns differently in the column properties via conditional formatting.

    pastedImage_0.png

    Edit: Sorry, I also forgot the image x-D

  • Calcioscacchi
    Calcioscacchi Rank 3 - Community Apprentice

    Ok, that means that I have to set a condition in each measure. But this system allows me to set a condition by value.

    How do I set something like "set color of  odd raws of this measure: 'light blue'"?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What are "odd raws"?

  • Calcioscacchi
    Calcioscacchi Rank 3 - Community Apprentice

    even (2,4,6) and odd(3,5,7) raws.