Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need a static chart which shd show,no of times user logged for Past 3 months
i given the dimension as user name and count(loginhistory)---> this is normal thing.
now i need the expression for the 3 months data for the login history and then the chart has to be static data.
example: this is November month, so i need only the last three moths data of login histoy for the user and that shd statc
static means any filter if i select,the cart should not change and 3 months data means , suppose if we are in december month means it shd show last three months data
i need expression to calculate the last three month data and how to make static for this requirement?
below is the data
USERNAME | LOGIN HISTORY |
x1 | 1/1/2016 |
x1 | 2/1/2016 |
x1 | 3/1/2016 |
x1 | 4/1/2016 |
x1 | 5/1/2016 |
x1 | 6/1/2016 |
x1 | 7/1/2016 |
x1 | 8/1/2016 |
x1 | 9/1/2016 |
x1 | 10/1/2016 |
x1 | 11/1/2016 |
x2 | 1/1/2016 |
x2 | 2/1/2016 |
x2 | 3/1/2016 |
x2 | 4/1/2016 |
x2 | 5/1/2016 |
x2 | 6/1/2016 |
x2 | 7/1/2016 |
x2 | 8/1/2016 |
x3 | 9/1/2016 |
x3 | 10/1/2016 |
x3 | 11/1/2016 |
x3 | 1/1/2016 |
x3 | 2/1/2016 |
x3 | 3/1/2016 |
x3 | 4/1/2016 |
May be like:
Count({1<[LOGIN HISTORY]={'>=$(=MonthStart(Today(),-3)) <=$(=Date(Max({1}[LOGIN HISTORY])))'}>}[LOGIN HISTORY])
for static?
yes