Forum Post: RE: How would I create a guage based on Conditions

[Ricardo Rafols]

Hi mysteryminds, The correct syntax for getCount is rbv_api.getCount(viewId, filterName, filterValue) try to use something like this: return Number(rbv_api.getCount('your viewer id', 'location', 'A')) + Number(rbv_api.getCount('your viewer id', 'location', 'B')) + Number(rbv_api.getCount('your viewer id', 'location', 'X')) + Number(rbv_api.getCount('your viewer id', 'location', 'Y')) + Number(rbv_api.getCount('your viewer id', 'location', 'Z')); Or you can use rbv_api.selectQuery("SELECT count(*) FROM your table WHERE location IN ('A','B','C','X','Y','Z')", 1)

Continue reading...