Hello, The end-user has requested the following, but I am having trouble adjusting the x-axis appropriately. I have a line graph showing activity over the "Trailing 12 Months" (TTM). It is currently January, so this chart is correct. However next mon...
Hi, I have a data set where i want to find out current date of count and Previous end date of the moth count . dashboard is showing Current and and historical Data in a one filter. I am tying yo achieve this using full outer join, i am getting curre...
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...
