Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Automatic switching between dashboards

This article explains how to automatically switch between dashboards every predetermined amount of time. This might come useful, when you have multiple dashboards that you want to be presented in a cycle on a monitor to reflect updated data\records. ...

Restoring dashboards default settings automatically

In this post you can learn how to automatically 'Restore Dashboard' on each page refresh or opening, this setting will always restore the dashboards initial published state for your viewers and designers. This can be used for cases where you would li...

Fields from the Dashboard (without scripting)

Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash files...

Community_Admin_0-1634470523769.png

Hide a column - Linux Pivot

Sometimes we would like to hide a column in our pivot table so we will be able to apply a specific logic or order the table by a column without displaying it. The following script will allow you to hide the needed columns in your Pivot table. To impl...

Community_Admin_0-1634394440994.png Community_Admin_1-1634394440939.png

Grid Charts

Analytical Need Sometimes we want to display 2 dimensions and one measure in a widget. Ordinarily we will use a pivot table for this purpose. A pivot table may be very nice & good but it doesn't allow us to filter the dashboard based on values from t...

Community_Admin_1-1634296258279.jpeg Community_Admin_2-1634296258524.jpeg Community_Admin_3-1634296258431.jpeg

How to see the latest date in the Pivot?

Question: How to see the latest date in the Pivot? Answer: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Array("Jan"...

Community_Admin_0-1634259092513.png

Filter Oldest Date For Each Product In A Pivot Table

Question: I'm attempting to select the First Time (day) each product in a list was ordered. Example:Product A | 10/10/2018Product A | 10/30/2018Product B | 09/01/2016Product B | 10/10/2018Result: Product A | 10/10/2018Product B | 09/01/2016 Answer: Y...

Object Count By Limiting Object Entries

Question: I have a list of items that have multiple date-oriented entries. I have a numerical field that indicates days since last scan, so I can filter based on the lowest number of days per item. What I am trying to do is count the number of items,...

Community_Admin_0-1634258724903.png

Custom/Starred Filters Not Appearing On Shared Dashboards

Question: I have created a custom starred filter, however, when i go to a different account that is not the admin, this does not appear on the date filter. Answer: Designers should be able to view starred filters when dashboards are republished, but ...

Community_Admin_0-1634258374974.png Community_Admin_1-1634258374978.png Community_Admin_2-1634258374927.png

How To Count Number Of Records Below/About MEDIAN/AVG

Question: I'm looking for a way to count number of records below and above median/AVG. Answer: Step 1: Add all category columns (Country, City, ID) to the Rows panel.Step 2: Add a column under the Value panel that calculates the total amount. The for...

Stacked Bar & Single Bar

Question: I want a Column Chart with 3 metrics- 2 of the metrics are stacked while one remains a single Column. I would even consider doing the 2 metrics stacked and the 3rd as a line, but if I choose 'Stacked' as my Column Chart Type, the ability to...

Community_Admin_0-1634257847586.png

How Can I Replace A Dashboard By ID?

Question: I have a dashboard that is referred to via a static Web page. I've developed a replacement dashboard but I want it to have the same exact object id number as its predecessor. So, I want to overwrite a dashboard ID with a completely differen...

Custom Date Filter "Since"

Question: I am looking for a solution to filter my data based on time period. I currently have data going back to 2016, but I want to filter it to show only entries for 04/2019 until today. Answer: You can do this with a custom-filter. Add your date ...

Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: