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.