One piece of information we're trying to understand is the frequency of tickets from customers when we onboard them and over time.
To start with this, we started tracking the date we onboard the customer (Go Live) and the date they no longer do business with us (Churn) in their Organization profile with Date fields.
In Explore, I tried to create both a custom Attribute and custom Metric to display the number of days between either today or their churn date.
However, when doing so, I am receiving an error.
If I simplify the formula to just the following:
IF([Go Live Date - Date] != NULL) THEN
DATE_DIFF(TODAY(), [Go Live Date - Date], "nb_of_days")
it will produce an actual number, however, the above error still occurs.
I've tried making this a standard calculated metric but also run into an error there with an even more simplified formula:
DATE_DIFF(TODAY(), [Go Live Date - Timestamp], "nb_of_days")
Before I even get to my actual end goal, I have to figure out why this is causing an error. Does anyone have any thoughts or insights on how to get this piece of information without running into errors?
Please sign in to leave a comment.