Avatar

Artem Yevtushenko

Sisense BI Consultant

  • Total activity 184
  • Last activity
  • Member since
  • Following 1 user
  • Followed by 1 user
  • Votes 54
  • Subscriptions 100

Activity overview

Latest activity by Artem Yevtushenko
  • Avatar

    Artem Yevtushenko created a post,

    Remove Columns That Contain All Nulls From Pivot Table

    Application Use this script in a pivot table where a column may have all NULL values to clean up the UI. The irrelevant columns are dropped after being loaded widget.on('domready', function(){ va...

  • Avatar

    Artem Yevtushenko commented,

    Hi Brian, the basic table widget should do this automatically! The pivot table widget encloses the cell text with span elements, so special characters for HTML are ignored. The basic table widget d...

  • Avatar

    Artem Yevtushenko created a post,

    Render HTML in Pivot Table

    widget.on('ready', function(){ var tags = $('tbody span:contains("<")'); for(var i = 0; i<tags.length; i++){ $(tags[i]).replaceWith(String(tags[i].textContent)) ...

  • Avatar

    Artem Yevtushenko created a post,

    Using "now" in a dashboard function date comparison with R

    Overview This post offers food for thought in regards to how R can be used to retrieve the real-time datetime with the RDouble function. It shows how to run date comparisons using the R syntax. Cha...

  • Avatar

    Artem Yevtushenko commented,

    Good luck! Also, did you replace "Average Units" with a measure of your own?

  • Avatar

    Artem Yevtushenko commented,

    Can you attach your RDouble formula? Considering the error is vague I would first test the function and forecasting model in R and make sure that it is returning appropriate results. Start simple b...

  • Avatar

    Artem Yevtushenko commented,

    Hi Hamza, The script uses a placeholder directory and Rscript name. Once you've written your model function you can save it to an R script and then reference the function from the Sisense function ...

  • Avatar

    Artem Yevtushenko created a post,

    Format entire record in pivot table based on dimension name

    Overview In this example the script goes through the pivot line by line and when it finds "Female" it colors the entire line light pink, its associated key pair value. It does the same fo...

  • Avatar

    Artem Yevtushenko commented,

    You can center the widgets in the widget rectangle by using this script: widget.on('domready', function(a,b){ $('.trellis').css('margin-left','20px').css('display','inline-block').css('float','non...

  • Avatar

    Artem Yevtushenko commented,