Clarity

Hi,

Maybe a miss something.

I need some guide on using Consistent Chart Colors, so I can use any color I want.

I tried to use the Chart Colors Char Pallete, but when I select use Consistent Color Key on the Chart and assign a source data value to it, it does not come with the color I need.
What is the catch? For exemple if I want the color of collumn to be cyan,(#00FFFF)  how should I pass this value to the chart ?

Have you checked this ?

Pie Chart Colors

https://communities.ca.com/message/9758843#9758843

NJ

Colors on a graph portlet

https://communities.ca.com/message/16200243#16200243

NJ

Quick Question : Bubble Charts

https://communities.ca.com/message/2291459#2291459

NJ

Thanks for the reply, but the post refers to the use of the color in sequence.

But even if we provide the colors key in sequence it does not work.

What if I want to use a color that is not in the pallete ? And if I use one of the colors of the pallete what is the Key value I must send to the chart ( from the query field ) ? A number, the color name or the color Web value ?

This is the query I am using for the Pie Portlet test:

• Linha is only used to number the records
• Quantidade is the Pie percentage
• Cor is the Key Color index
• Descrição is the Value Label

SELECT

@SELECT:DIM:USER_DEF:IMPLIED:PROJETO:ROW_NUMBER() OVER(ORDER BY B.QUANTIDADE DESC):linha@

,@SELECT:METRIC:USER_DEF:IMPLIED:B.QUANTIDADE:QUANTIDADE:AGG@

,@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJETO:B.COR:cor@

,@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJETO:B.DESCRICAO:DESCRICAO@

FROM

(

SELECT

25 QUANTIDADE

,'VALUE 1' AS DESCRICAO

,  0 AS COR

FROM DUAL

UNION

SELECT

25 QUANTIDADE

,'VALUE 2' AS DESCRICAO

,  1 AS COR

FROM DUAL

UNION

SELECT

25 QUANTIDADE

,'VALUE 3' AS DESCRICAO

,  2 AS COR

FROM DUAL

UNION

SELECT

25 QUANTIDADE

,'VALUE 4' AS DESCRICAO

,  3 AS COR

FROM DUAL

)  B  

WHERE @FILTER@

AND  @HAVING_FILTER@

The Results:

Default Colors:

Consistent Colors:

Color Pallete:

So unless I am doing something wrong, this is very strange. When you select Default Colors in the Chart it uses the Color Pallete. When you select Consistent Colors it uses a strange color sequence and does not uses any of the color in the color pallete.

Hpoe this helps understand and gives us some light over the subject before I open a ticket in CA support.

I don't really recall the details of this, but a few years ago when I was trying to get various portlets to use a consistent colour-palette I could ONLY do this using the 'default colors' method (and amending the colours in the system palette to fit my requirements). If I recall correctly, the 'consistent colors' method was something that meant consistent in a user-session rather than consistent as defined at code-level (not sure if that makes sense).

Hi Dave, Thanks for the reply.

I did some test in another clean environment and found that it is working. ( IT seems that the client Clarity installation is with some problem - checking to see if this is the problem ).

The colors must be in the Color Palette.

If you use Consistent Colors in the Chart  ( a pie chart for example ), you can choose the color you want by giving the index number of Color Palette. So if you want your value to use the red 14 color, the black 4 color, the white 5 color and the DarkOrange 6 color , you would use as index 14, 4, 5 and 6 for the color number.

If you use the default color palette, then you must use the color as you explained in your other posts.

I will run more tests and let you know the results.

joni.campos did you have to change anything in your query?

how do you pass the color index number? I never knew we could do that...