Possible function issue in set analysis

ashokraju — Mon, 11 Jul 2022 14:59:11 GMT

Hi

I am using possible function in set analysis but it is not working based on month dimension.

My scenario is if a salesrep belongs to particular state then i am bringing user count for all the states.

count( {< salesrep=p(state) , date={>=startdate<=enddate} >} users)

and in straight table iam showing

month,state as dimension and expression as --> count( {< salesrep=p(state) , date={>=startdate<=enddate} >} users)

if i select single month in the top filter it is showing correct value
but if i select last six months possible function is evaluating based on six months and it is not aggregating with month as jan, feb,mar,apr..so on..

it is showing entire six months sales rep count in each month.

It would be great if anybody can guide us

Re: Possible function issue in set analysis

MendyS — Sun, 17 Jul 2022 12:56:47 GMT

hi

Have you tried using the AGGR function?

something like - Aggr(count( {< salesrep=p(state) , date={>=startdate<=enddate} >} users),Month)?

topic Re: Possible function issue in set analysis in App Development

Possible function issue in set analysis

Re: Possible function issue in set analysis