• Replies 10 replies
  • Subscribers 962 subscribers
  • Views 400 views
  • Users 0 members are here
Related

Analytics Date & Time Functions

Gustavo Mansilla
$organization

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

Parents
  • $organization

    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 formatting
    widget.on('ready', function(se, ev){
    var evalCol = 4; //fidx val of column to evaluate
    var formatCol = $('td[fidx='+evalCol+']'); //jquery pull entire eval column into array

    $.each(formatCol, function(a, b){ //function to loop through array
    if($(this).attr('val') > 0) { //evaluate text conent of each cell in column's array. note: need to use JavaScript this instead of JQuery $(this), since textContent is a JavaScript attribute.
    $(this).css('color','green'); //set conditional styling
    }
    else if ($(this).attr('val') < 0) {
    $(this).css('color','red');
    }
    });
    });

    7608.ArshtCenter_SiSenseDateTimeFunctionExamples_2019-12-17.dash

  • $organization in reply to Daniel Gomez

    Alright, Alright, Alright Daniel!!

    I see what my problem was now....I was using the Season Fiscal Year as "Date" but certainly it is not...hence I was getting nothing.

    This is fantastic.....I highly appreciate your answer my dear Floridian fellow. I owe you a beer, coffee, sandwich or anything you like so please let me know when you are visiting Naples.

    Gustavo

Reply
  • $organization in reply to Daniel Gomez

    Alright, Alright, Alright Daniel!!

    I see what my problem was now....I was using the Season Fiscal Year as "Date" but certainly it is not...hence I was getting nothing.

    This is fantastic.....I highly appreciate your answer my dear Floridian fellow. I owe you a beer, coffee, sandwich or anything you like so please let me know when you are visiting Naples.

    Gustavo

Children
No Data