Hi Sisense Community! I would like to write a script to remove the first row of the pivot table in my widget. I don't want to use an advanced filter, as I already tried that and using a filter affects the rest of the values since I use a DIFFPASTWEEK...
Hi Sisense Community! I have a question with regards to dashboard design: For the pivot table widget, would it be possible to add category headers for the metric columns like this? I have pivot tables with several metrics, so it would be ideal to gro...
I have a dashboard with three filter buttons made from BloX that will filter the dashboard for specific time ranges (last 2 weeks, last 4 weeks, last 8 weeks). These buttons work as expected by creating a custom filter when there is no option that ma...
Introduction The following article answers a use case where each user/group in your organization should see their data in a different format. This logic can be applied to various measurements: Currency (USD/NIS/EUR/etc.) Distance (KM/Mile) Temperatur...
When creating a Pivot 2.0 chart (Linux) you may want to hide a specific column. There are various reasons for doing so: I want to sort by a column that shouldn't be displayed I want to display a column when exporting the table to Excel or CSV, but hi...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Hi, Can I manipulate card view for individual widgets and also easily make changes to set the card view type border only for certain sides of the (Top, Bottom, Left, Right) widget? Thanks
When sharing a dashboard you might want to prevent the user from seeing the "Analyze It" buttons on the widget's title bar Add the following dashboard script: dashboard.on('widgetready', function(dash) { $('.analyze-it-button').remove()}) Before Afte...
I want to make the iteration over the Form Name marked(in red) in the below image. So, basically here there is a header name which has some attributes and their corresponding values which is different for every header and also there are multiple such...
Hi, I referenced this post to arrange widgets https://community.sisense.com/t5/build-analytics/arranging-widgets-in-a-dashboard/m-p/2827 I want the widgets I am referencing to remain on the same dashboard, but I want to hide them so that they are onl...
Introduction The following article discusses how to manipulate the data and styling of your Pivot 2.0 widget.Please refer to the following article first: https://sisense.dev/reference/js/widget/pivot2.html. Cell Identification To manipulate a pivot c...
Hi! I am creating a pivot table and I currently have all the values populated until the end of this year. However, I would only like to include values up until the previous week, which is a dynamic date. Is there an advanced filter I could use that w...
Hi! I have an indicator widget that is updated weekly to show the latest weekly values. As such, I would like to have a line underneath this number that says something like 'updated as of *latest week date*' . The date would have to be updated based ...
I'm starting out trying to create Blox widgets. Most of these are not intended extend dashboard functionality to show sparklines and to put filters on the dashboard rather than to the side of it. So I'd like these widgets to fit in with the styling o...
A customer may want to pass a filter value using the URL (as a parameter). A common case could be when an external system launches a dashboard and wants it to default to a specific value.The following script allows you to parse the parameters receive...
Sisense limits a user from defining more than 3 column values to make sure that the underlying SQL (group by) query doesn't get too complex (notice the missing '+'): However, in some cases, a user would like to add more than 3 values. These include: ...
