In Windows, with pivot1, we were using the following script to replace null values with a dash (-). We've moved to Linux and are aware the script will not work. What script should we use to accomplish the same replacement? Old script: widget.on('re...
I have a blox widget that outputs NaN:NaN:NaN. Can I apply a script to replace this with a hyphen?
Hi all, CONTEXT ------------------We use GenericJDBC connector with custom queries to fetch data from our mongodb data source on Sisense. Our data model is similar to a star schema with one DIM table and several aggregated fact tables. Till date we h...
Hi Team,Can we rename elastic cube in web?? , I haven't find any option there.Thanks in Advance
@harikm007 Hi, My use-case detail: We have a table in our data model with "updated timestamp" column in GMT timezone and another column which has the country name. This country name is one of our dashboard filters. The requirement is to convert the ...
I'm currently using the Wiser Filter widget plugin to display some dropdown filters on a dashboard, but I would like to add some more involved filtering (where I potentially apply filters to two columns at once) using BLOX.I really like the styling o...
Hi Team, We have requirement where we need to update dashboard date filter dynamically from selected date to Last 365 days from the date selected. We have a working code for windows, we are looking the same for Linux, attaching the windows code below...
Hi Sisense Community.. I am having an issue in arranging the x-axis labels in Heat Map. In this first we have chosen scatter chart and then converted in to heat map using the below code widget.on('beforeviewloaded',function(se,ev){ev.options.chart.t...
Hi team,I want to manually sort x axis and y axis categories in the scatter chart.Please share the script. Screenshot is attached for your kind reference.
Hello, I've been trying to build build a widget (NUMBER) where I get the total Count of PatientId with more than one appointment in the same day... I was able to build a pivot table but I am confused when I try to replicate the calculation in other ...
Hello All, In this screenshot Product counts column, it is calculated by taking count of product (by selecting count) in power bi, as shown in second image (like in black C - 1& J - 29, in chatri(SL) J -20) etc. So how to calculate counts of product ...
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 displayedI 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, We are seeing the error message mentioned in the subject for two types of charts (Area map and Scatter plot). For Areamap, this error is throwing up 16 times on hovering over the tool tip. For scatter plot, the same error is multiplying on hoveri...
Hi Team, I am creating a text block using blox. However, even after chosing text align to "left" the result is still coming to the centre.See the screenshot below and the code I am using. Thanks in advance Code: { "style": "", "script": "", "titl...
Hi, We are writing tool tip customization scripts inside the widget "process result" event. we would like to handle the same logic at dashboard level, which event should we need to use to have the generic script for the tool tip customization for all...
