Solved

No Logins in 2 Weeks Rule - Transformation Task

  • 2 November 2020
  • 4 replies
  • 122 views

Userlevel 3
Badge +1

I’m trying to create a rule that will identify which accounts haven’t logged in the last 2 weeks. We use PX and have mapped “user logged in” as a feature. Feature name is a field in the GS PX to CS Company Time Series Daily object, so I’ve created a task in the rule to bring in feature name from that object. I’m guessing I need to use a transformation task to figure out if that feature was used in the last 2 weeks, but I’m not sure how to configure that task and/or which formula field to use. 

 

Any help would be greatly appreciated!

icon

Best answer by dan_ahrens 5 November 2020, 14:25

View original

4 replies

Userlevel 7
Badge +1

Hi @jriva - this is a fairly common use case - to report on some sort of absence of data. In this case, you want to show not the accounts that have the “user logged in” event in the last 2 weeks but the ones that did NOT have that event in the last 2 weeks, right? 

 

Have you checked out our weekly office hours? It’s every Thursday and if you submit your question in advance and join the session, one of our Gainsight experts will walk through how to solve this problem live! 

 

 

Userlevel 3
Badge +1

Thanks Dan, I have submitted my questions and will be attending this Thursday’s session to hopefully get a solution for this use case.

Userlevel 3
Badge +1

@dan_ahrens btw, Scott was able to help me get this set up during office hours. Thanks for pointing me in the right direction, it was probably the best learning experience I’ve had yet since I’ve become GS admin.

Userlevel 7
Badge +1

That’s great! Glad to hear that office hours were helpful for you. :)

Reply