Hi,
I've been trying to understand how the functions in analytics work so I can use them properly. I've had some success with a few of them that I think are going to be very useful but there are some others that no matter what I do, either I get an error message before I finish writing the formula or I get zero results or an error for the full widget.
They are basically the date & time functions Growth, Growhrate, , GrowPastMonth, Past Month, Past Year....etc etc etc. I see the explanation of the functions by hovering over them and it certainly is easy to understand but it does not have clear examples of the syntax we need to use, which I am certain is my problem. I looked around the Tessitura dashboards but it looks like none of them are using any of these functions..
When I google them I can find some similar functions, even Sisense has a couple of guides out there but again, no practical examples that shows the proper syntax.
Does anyone have had any success using these functions? ...
Thank you very much in advance.
Gustavo
Hi Gustavo,
If you have a look at the documentation in Analytics and search by the function name you'll get the examples with syntax.
https://www.tessituranetwork.com/Tessitura_Analytics/Tessitura_Analytics.htm#Designing%20Dashboards/Quick%20Functions.htm?Highlight=growthrate
https://www.tessituranetwork.com/Tessitura_Analytics/Tessitura_Analytics.htm#Designing%20Dashboards/Quick%20Functions.htm?Highlight=pastmonth
Hi Heath....and thanks for your reply.
I actually checked the documentation for these functions and what I found as an example of the syntax is this:
PASTMONTH(<Numeric Value>)
....which is the same for the rest of the functions.
Is that what you mean?...if it is, I tried using it that way and I keep getting no results. I believe the function needs to include some kind of date or date period parameter but I do not know how to include it.
Thanks again.