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 --
Here are some examples of using these functions that I threw together quickly. The secret to using these functions is that you must have a date/time column included in the widget, otherwise, SiSense has nothing to evaluate the functions against. Lots of much fancier ways to present the data you're interested in depending on the visualization that best tells the narrative you are trying to present.
I've also included below a pretty simple script you can use to conditionally format the color of text within a Pivot Table column based on value.
//Text column formattingwidget.on('ready', function(se, ev){
});
7608.ArshtCenter_SiSenseDateTimeFunctionExamples_2019-12-17.dash
I had difficulties importing this dashboard. I use the import function. Then nothing happens. I don't even see an attempt to load the dashboard.
I do import dashboard. And no-new dashboard appears.
I've been able to load the .dash file from RAMP Tessitura Client. However, I can not load exactly the same file from Tessitura on the Go Started Tessitura Analytics. I've opened a ticket with the Support team.
I just imported it via TontheG Tom (wish we had Hamilton)