Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
Have you tried using the AGGR function?
something like - Aggr(count( {< salesrep=p(state) , date={>=startdate<=enddate} >} users),Month)?