A few days ago I posted a support ticket for the "DateDiff" function within a transformation as it was not allowing me to select "Weeks" from my units of measure and ONLY Days. While the documentation online states there should be many selections for this function (Days, weeks, months, etc), it was not appearing and there are time-sensitive deliverables for me (Admin) that required this information to be calculated properly.
Not only did we derive a solution, but I also was able to learn a valuable thing about GS that perhaps I missed or overlooked in training, and here it is:
You can perform and data transformation on an existing data transformation! (cue heavenly choral singing!)
So since we were able to only derive Days from the function, GS Support created a second transformation that converted the initial one to weeks by dividing the previously established DAYS by 7.
HUGE KUDOS AND SHOUT OUT TO @ankur_bhat you provided excellent support and rocked this issue!!!! And BIG THANKS to all support members involved and their rapid attention, responsiveness and creativity!!!!
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.