ContributionsMost RecentNewest TopicsMost LikesSolutionsSupport Portal Update and Revisions Scheduled for Release May 17th Read to learn more about the upcoming release of the latest, revised version of our case management portal. Support is Moving to the Sisense Community Sisense is excited to announce we are currently undergoing a significant transformation to facilitate quicker response times, increase the quality of solutions provided, and reduce our total resolution times. Read our newest blog to learn more about our revamped Support model. Re: How to Update Sisense Instance After License Changes Please see above, the first part of the article talks about Linux Re: FILTERED JTD BASED ON LIST ROW ITEM Hi Carter, Please take a look at this article ,https://support.sisense.com/kb/en/article/jump-to-dashboard-filter Thanks, Ronen Re: Pie Chart Colors from Database Hi, There are several ways you can achieve this, we will need a better understanding of the use case to recommend the best option. At a very high level this can be done using Javascript, see link below to give you an idea https://support.sisense.com/kb/en/article/change-color-for-specific-category-in-pie-chart If you are looking for a more generic option where you read values from the database, then you would need to create a custom plugin , https://support.sisense.com/kb/en/article/create-a-new-plugin , utilize the ProcessResult callback to read the colors and set the color object accordingly. If you need help with this , please reach out to you Customer Success Manager , who can set you up with our Professional Services for consulation. Thanks, Ronen Re: Percentage Increase on Bar Hi, You can use Sisense quick function, https://documentation.sisense.com/docs/quick-functions#:~:text=Quick%20Functions%20instantly%20add%20a,time%2C%20contribution%20and%20running%20totals. In your example you would use % Change over Time and then select Growth (See attached screenshot) Re: How to remove blank space at the bottom of the dashboard Hi Wojtek, Can you please open a support ticket as we need to better understand the use case and what you looking to do. Thanks, Ronen Re: PastDay formula Hi there, your best option is to solve within the data model. If you data doesn't produce any value for Sunday, the just rollover the value you have on Sat to Sun using custom SQL. This more of a data issue that will need to be fixed within the data model. Hope this makes sense. Ronen Re: Regarding manipulating a text in widget. Hi, You can use a standard Text widget, and add the following code: widget.on("ready",function(se,ev){ document.getElementById("editor-3").innerHTML = "whatever"; }) Best, Ronen Re: How to create Custom Columns: ThisWeek, ThisWeekPrevYear? Hi, You will need to add a custom column to flag is a specific date is within the range of Monday - Today for every row, so everything you build the EC is will get updated. Let say 1 to include, meaning it is M-Today and 0 not. Use this as Widget filter to start with. You can then in your formula use a formula filter to calculate the value 53 week ago (Use the advanced option), and you code will look like the below: { "last": { "count": 1, "offset": 53 }, "custom": true } The above formula together with M-Today filter will give you what you are asking. Hope this helps