Suppose I have data organized in a pivot (widget). where within the pivot table, each rows represent a team member, e.g. (jack, jon, doe etc). The team members are part of teams, where 'team name' is a column in the same pivot (widget) I'd like to ge...
Hi! I'm creating a dashboard and want to show when the data source for the dashboard was last refreshed at the top of the dashboard, since the users will want this. Is there any widget I can add or script to add to achieve this?
Here is a blox template for cards Refer : https://www.binextlevel.com/post/blox-template-2-cards Blox Editor Script: { "style": "", "script": "", "title": "", "showCarousel": false, "body": [ { "type": "ColumnSet", "columns": [ { "type": "Column", "s...
Hi all, Sisense 2022.6 comes with Filter relationships. It says it requires the analytical engine to create these relationships. Does this mean this feature is only available for live models? Or is it also available for Elasticubes? Kind regards,Sche...
I'm trying to create a slightly more restrictive text filter using Blox. I want my users to be able to type in a search term to filter on, but I only want them to be able to do a 'contains' filter, not the other free text filter options.I've managed ...
Hi - We have a requirement to access Sisense User Id in the Live model SQL Queries. Do we have any way we can access the Sisense User Id/ Group via some variables?
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...
