Forum Discussion

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
2 years ago
Solved

show growth over time

I have a log table that contains an action, user id and date/time.    I would like to produce a line chart that shows continual user growth over time.  the Title column would need to onl...
Need Help
  • nick9one1's avatar
    nick9one1
    2 years ago

    I think I've figured this out. 

     

    I created a column that has a 1 for the first appearance of each user email;

    First Login = 
VAR _class =
    CALCULATE(
        MIN('Log'[Date]),
        ALLEXCEPT('Log', 'Log'[email])
    )
RETURN
    IF('Log'[Date] = _class, 1, BLANK())

     

     

     

     Next I created a measure to count the logins cumulatively (dark blue line)

    running sum = CALCULATE( 
 SUM('Log'[First Login]), 
 FILTER(ALLSELECTED('Log'), 
 'Log'[Date] >= DATE(YEAR(MAX('Log'[Date])),1,1) &&
 'Log'[Date] <= MAX('Log'[date])
 ))

     

     

     

     

     

     

nick9one1's avatar
nick9one1
Icon for Helper III rankHelper III
2 years ago

I think I've figured this out. 

 

I created a column that has a 1 for the first appearance of each user email;

First Login = 
VAR _class =
    CALCULATE(
        MIN('Log'[Date]),
        ALLEXCEPT('Log', 'Log'[email])
    )
RETURN
    IF('Log'[Date] = _class, 1, BLANK())

 

 

 

 Next I created a measure to count the logins cumulatively (dark blue line)

running sum = CALCULATE( 
 SUM('Log'[First Login]), 
 FILTER(ALLSELECTED('Log'), 
 'Log'[Date] >= DATE(YEAR(MAX('Log'[Date])),1,1) &&
 'Log'[Date] <= MAX('Log'[date])
 ))