How to handle color dynamically?

[durgabhavani]

Hi All,

Please help me to handle color dynamically.

I have customer code in my application and assigned one color to each customer code. Now problem is whenever new customer with new customer code come on to my dashboard, I need to assign one new color dynamically to that customer without my intervention.

how to handle. Please advice

Please find the attached sample application.

Thanks,

Durga

[tresesco]

May be something like:

Pick(Match([Customer Code], 'SA1', 'SA2', 'SA3', 'SA4','SA5')+1,Color(RowNo(total)),$(v_color_CC1),$(v_color_CC2),$(v_color_CC3),$(v_color_CC4),$(v_color_CC5))

[durgabhavani]

Hi Tresesco,

Thanks for reply.

I am bit confused to implement in my app. Can you please apply in my application?

Thanks,

Durga

[shraddha_g]

Create a Excel with Customer Code and Associated RGB Code.

Link this source in Data model with Customer Code and user RGB Code field in Expression for color

[durgabhavani]

Hi Shraddha,

I have created variables and user RGB for existing customer codes and successfully displaying on dashboard. But problem is with when one new customer code comes to dashboard, how to add new color dynamically?

please advice.

Thanks,

Durga