Count aggregation that includes previous and current values
I have 4 Type of Users:
I have a column where says the number of times a specific type of user has ran a query in a specific month and year
Now, I am trying to create an expression that counts the number of users that are equal to "User" that has executed a query the previous month and current month. Therefore, I am looking for repeat users. For example, Peter is a "User", he ran a query on Sept 2015 and Oct 2015 he will be count it as a repeat user.
My script look like this:
"Query Type" as [Query Type Historical],
date(date#("Cal. year / month",'YYYY-MM'),'MMM-YY') as [Cal. year / month],
This is the expression that I have used but it doesn't work: