Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
I have a requirement that I should get the unique count of login names for a particular month and if it is repeating again in next I should not take it consideration for unique count for the next month .
For your reference I am attaching the qvw file and output I am getting .
Please find the below desired output
Month | Unique Distinct Count(Checking with previous months) | Unique Count |
---|---|---|
Jan 2015 | 3 | 3 |
Feb 2015 | 3 | 4 |
Mar 2015 | 1 | 5 |
Thanks in Advance
Sreehari
Check this
Check this app
Hi Anbu Cheliyan,
Thanks for your solution.
Can you confirm that is it is comparing the whether the occurrence of Name had happened with all the months before but not the one month before .As per my understanding it is only checking only previous month but not all the previous months.
Thanks
Sreehari
Only one previous month.
What is your requirement?
I have to check all the previous month
Check this
Hi Sreehari,
Write the expression as
=count( If(Count=1,Name))
You'll get the same result which you want.
Thanks and Regards,
Ankita
Thanks Anbu Cheliyan and Ankita for your solution..
Let me check with my current original data will it work prefectly or not ..
Sreehari
Hi Anbu Cheliyan,
Can you explain me how the Autonumber for this solution?
From QV help,
autonumber(expression[ , AutoID])
Returns a unique integer value for each distinct evaluated value of expression encountered during the script execution. This function can be used e.g. for creating a compact memory representation of a complex key.
In order to create multiple counter instances if the autonumber function is used on different keys within the script, an optional parameter AutoID can be used for naming each counter.
AutoNumber(RowNo(),Name) -- Each Name is used as counter and RowNo() generates from 1,2..N for each Name based on rows you have in your source