Resolved! Blox: Replace NaN:NaN:NaN with '-'
I have a blox widget that outputs NaN:NaN:NaN. Can I apply a script to replace this with a hyphen?
Forum Posts
Issues with Incremental Build on JDBC table
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...
elastic cube rename
Hi Team,Can we rename elastic cube in web?? , I haven't find any option there.Thanks in Advance
Convert timestamp from the data model to a different timezone based on the dashboard filter
@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 ...
Resolved! How to create custom action based on a BLOX dropdown filter (+Styling the filter)?
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...
Update Dashboard Date filter from selected Date to Last 365 days
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...
Issue In Sorting X-axis Labels
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...
scatter chart manual sorting of x axis and y axis categories
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.
How can you Count the number of patient with more than one AppointmentId in the same day
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 ...
Calculating Count of function
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 ...
Pivot 2.0 - Hiding Columns from the Display
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)
TypeError: Cannot read properties of undefined (reading '0')
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...
Text Block Left Align
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...
Tool tip customization
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...
Resolved! Can't get text to vertically align between columns in Blox widget
I'm struggling to get the text in 2 adjacent columns in a Blox widget to align. It doesn't even really matter how, top/middle/bottom, as long as there is some degree of alignment. I created a very basic test script to see what's going on and essentia...
