7 Replies Latest reply on Apr 7, 2016 2:10 AM by Swarup K

# Color Coding for multiple KPI's in One sheet.

Hello All,

Please find the attached excel sheet.

I have 2 KPI'S (FBP Balance daily and IBP Balance Daily) I want color coding for 2 KPI's in same sheet in CROSSTAB format.

if FBP Balance daily <0 then red else green end.

if IBP Balance daily <0 then red else green end.

I am using 9.0 version.

Regards,

Koushik.

• ###### 1. Re: Color Coding for multiple KPI's in One sheet.

Hi Koushik,

I have taken your measure values (FBP_Balance_Daily, IBPB_Balance_Daily) and added some sample to it like (day wise) and created a color coding for both measures like below:

I think it helps.

• ###### 2. Re: Color Coding for multiple KPI's in One sheet.

Hello Kumar,

For march 24th, color coding is showing incorrect as per your screenshot.

7258 should show green but it showing red.

Regards,

Koushik

• ###### 3. Re: Color Coding for multiple KPI's in One sheet.

Hi Koushik,

This can be done through conditional formatting. Attached image for  your reference.

Mark correct if this helps you.

Thanks

Raj

• ###### 4. Re: Color Coding for multiple KPI's in One sheet.

Hello Raj,

thank you for the mail. can you explain me with detailed steps. how can I take these attributes? and formatting it? any calculation required?

can u provide me screenshots for each? this wud help me in creating workbook from my side

regards,

Koushik

• ###### 5. Re: Color Coding for multiple KPI's in One sheet.

Hi Koushik,

You can able to do by your own.

Thanks

Raj

• ###### 6. Re: Color Coding for multiple KPI's in One sheet.

Howdy Koushik,

The link from Raj will work for you this technique is called forklifting. We need to do this because we get only one colour scheme per marks card. So what we do is make multiple new axis, this is the ATTR(1) reasoning,

You make a new calculated field with just 1 in it as the calculation. Then drag it to the columns shelf and change the aggregation from measure to ATTR, min and max work as well.

MIN or MAX is preferred as Attribute is a bit slower as it actually tests both min and max and then compares the values together.

Alternatively we can use number of records and take the MIN of that onto the shelf instead.

By using multiple axes and we gain access to multiple marks card. Multiple marks cards means multiple color schemes or multiple conditional formatting base on KPI

Cheers!

Carl Slifer

InterWorks

• ###### 7. Re: Color Coding for multiple KPI's in One sheet.

Only one field can be used in the Color legend.  To overcome this you need to Create a calculated fields and convert it to ATTR.

1 of 1 people found this helpful