Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try calculation condition like:
=Len(MaxString([KPI Name]))
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'
Ok, try this as calculation condition: =count([KPI Name])