Text color in chart

[Anonymous]

Hi guys,

I have 2 the same charts. First chart - I combined 1 dimension; second -without combined.

I want to show different text color for my first chart.

The problem-when I combined my dimension (from 3 tags to 2 tags), stop working text color expression for combined tags.

Do you know how to resolve this issue?

Please see my attached file.

Thanks,

[iktrayanov]

Is that what you need?

[Anonymous]

No, I want to compare First time visitors with first -time visitors.

Something wrong with aggregation function

Please see attached file.

[iktrayanov]

You have problem with the above() function it returns null in some cases.

[Anonymous]

I don't understand why it works in Pivot table.

I just replace before to above.

[Anonymous]

I think it can understand my dimension

=If([qID_9705_Visit Frequency]='First time','First-Time Visitors',If([qID_9705_Visit Frequency]='2 to 5 times',

'Repeat Visitors',If([qID_9705_Visit Frequency]='6 times or more','Repeat Visitors',[qID_9705_Visit Frequency])))

in the chart

[iktrayanov]

I would try to create the calculated dimension in the load script. Because the bottom chart seems to work with normal dimension.

Regards,

Ivan

[Anonymous]

I did it.

it works. when I created the same condition in load script.