For march 24th, color coding is showing incorrect as per your screenshot.
7258 should show green but it showing red.
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
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
1 of 1 people found this helpful
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.