Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am using the below expression.
=if(Aggr( Count( client) , client)<=1, '1 time Visit'
,if(Aggr( Count( client) , client)<=2, '2 time Visit'
,if(Aggr( Count( client) , client)<=3, '3 time Visit'
,'More than 3 Visit'
)))
But it always give the 1time visit also not calculating correctly.
Please help me to get all the 3 buckets also looking for alternative solutions.
Thanks in advance
Thanks.
Hi,
Do you have any other dimension in your chart?
The above suggestion is working for me.
Thanks for your solution vamsee duggirala. It's working for me. I'm using the below expression.
=
Aggr(
IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=1, '1 Time Visit',
IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=2, '2 Time Visit',
IF(Count({1<[Source]={'xxx'}>} Client & [Name])<=3, '3 Time Visit',
)))
,Client)
But, I'm facing another issue. I have a donut it display all the three categories. But If selected any category example '1 time visit'. it will display client on the filter panel.
I have tried to some solutions. it's not working
Kindly advice
Thank,
Selva
For that, you might have to create this column in the script.
Interesting, it seems to work for me.
Maybe you can describe your issue well enough so it can be solved?
hope this helps
regards
Marco
So a client selection defines a non working solution per your requirement?