Calculation Condition in chart doesn't work

[viveksairam89]

Hi 

I have a site Table1  and KPI Data table2,

i am using a chart ,just i want to display red or green based on the site,if the KPI name is steel and kpi value is 1 it should be green or else it should be red,if the site doesnt have value then it should produce a Display message No data for the site

I have attached the QVW iam getting the problem in calculation condition

Table1:

Site	Country
Mumbai	India
Chennai	India
Banglore	India

Table2:

Site	Country	KPI Name	KPI Values	Month
Mumbai	India	steel	1	Sep-18
Mumbai	India	Plant	1	Sep-18
Mumbai	India	Water	1	Sep-18
Banglore	India	steel	0	Sep-18
Banglore	India	Plant	1	Sep-18
Banglore	India	Water	0	Sep-18

[tresesco · Accepted solution]

Try calculation condition like:

=Len(MaxString([KPI Name]))

[Gysbert_Wassenaar]

To be honest I have no idea what you're trying to do. However 'Steel' and 'steel' are two different values. Make sure to use the correct value.

[viveksairam89]

Thanks for the reply

I am trying to put if steel value is 1 its Green Dot,else Steel value is 0 its should be Red Dot based on the Site

If Selected site doesn't have Value it should display a message 'No Data for Chennai'

[Gysbert_Wassenaar]

Ok, try this as calculation condition: =count([KPI Name])