Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have an issue regarding counting the remaining data.
ex.
on default it show 41 users who have logged in but after selecting a particular date it shows 40 user logged in.
Now I want to see the count of the remaining user and also after clicking it to show the user who have not logged in on that dat.
pls do help.
Regards.
One option could be
Count(DISTINCT {1} Users) - Count(DISTINCT Users)
or
Count(DISTINCT {1-$} Users)
Hi
Assuming Date and User are your fields
Try this in Text box
=if(Aggr(Sum(1),Date)>0,
'Selected: $(=Count(DISTINCT (users))',
'Others: $(=Count({<Date=E({$} date)>} Users))’)
or
Try this is in Pivot table (For Remaining Users)
count(Distinct {<Date = E({$} Date)>} Users)
One option could be
Count(DISTINCT {1} Users) - Count(DISTINCT Users)
or
Count(DISTINCT {1-$} Users)
You have always out of box ideas.....!!!
Thanks the first one worked for me.!
Yes, I was not very confident about the second expression myself (that's why listed it second). But I am glad 1st one worked for you
Best,
Sunny