OrderNumber in a chart

[Anonymous]

Hi,

There is a chart where any set of brands may be displayed

For each brand in this particular chart I'd like to calculate an OrderNumber and according to this order number set a color using a Color function.

I tried this formular:

color(RowNo())

It fails to work correctly for my chart, maybe, it is because my chart is rather complicated.

Is there any other way to calculate an OrderNumber in a chart?

Thank you in advance,

Larisa

[sunny_talwar]

Can you send a screenshot of what happens when you convert the above into a straight table?

[Anonymous]

See the file attached.

[sunny_talwar]

I see the problem now. Let me fix it and resend it in a bit.

Best,

Sunny

[sunny_talwar · Accepted solution]

Can you try it now?

[Anonymous]

Thank you, it works!

Is Aggregated Dimension the only solution?

The point is that I would not like to use an Aggregated Dimension if possible.

larisa

[sunny_talwar]

We did try the other option, which wasn't working for you (for some reason). I don't know a third way to do it just on the front end of the application. I can suggest you a back end way, but that won't be dynamic based on your selection which won't be very useful in your case.

Best,

Sunny

[Anonymous]

Thanks, Sunny!