I have data like below table in which i am showing Region wise Total Visits done on a store by ABM. Now suppose i have 3 KPIs : Inventory Support , Price Drop Module, Demo Validation . It shows count of stores that have filled these modules respectively.
Query : I need to create a 3rd KPI : Total Activities which will show count of Modules/KPIs filled (Inventory Support, Price Drop Module, Demo Validation) . So max value will be 3 and min will be 0. Is there any function which can be used for this in chart instead of using nested if else.
| Region | Total Visits Done | Inventory Support | Price Drop Module | Demo Validation | Total Activities Done |
| East | 105 | 5 | 0 | 0 | 1 |
| West | 200 | 3 | 4 | 5 | 3 |
| North | 300 | 2 | 3 | 0 | 2 |
| South | 98 | 0 | 0 | 0 | 0 |
