I have created a Blox Dynamic Pivot Table that I have transposed so that the columns are months and the rows are calculated values. I would now like to update the table so that the month displayed in each column is actually the next month (e.g., Apri...
I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this:SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK)INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK)ON R.PKID...
Hey,So I used the following widgetscript to alter the font in a pivot-table. In the dashboard these alterations are visible, however when exporting it to PDF the pages are all blank. widget.transformPivot( {}, function (metadata, cell) { cell.style =...
Hi @Angelina_QBeeQ ,I want to set color(red & green) of Rank cell based on Overall Vol measure.if Overall Vol>2000 then Rank cell will be Red else Green.Logic of Overall Vol is Count(call)
We have an activity by customer dashboard that allows the end users to changes customers using a dashboard filter. One of the widgets on the dashboard is a pivot table displaying basic information about accounts that are related to the account that i...
Is there a way to increase Maximum number of series for break by in the column chart?
@prosupport , @community_int , Sisense Team, I am trying to find the list of available fonts in Sisense cloud, but I see only few. I want to use other font (Calibri for example). Do I need to buy license before uploading or can I upload any fonts in ...
Hello! I'm trying to create a formula that will calculate the number of days between two dates. The first date would always be an "Open Date", which all items should have. The second date would be conditional: I want it to use a "Closed Date", or if ...
Hi everyone! Is there in Sisense a possibility to limit viewer logging in from one account, like a "concurrent" logging? So, if the user logs in with his username, then this username logs out of Sisense on all other devices where the login was previo...
Hey everyone, I’ve got a table with an opening balance that shows the date and total quantity on that date. There’s another table I’m working with that has transaction details and their values (transaction date and quantity). What I want to do is dis...
I have a table widget it's have event number 1,2,3,4,5,6,7 with some shipment keys. I created a max event number (new column in new table) with grouping of shipment key customer want to see only max event number row only. how to achieve this. actual ...
Have a csv file that is being created out of a platform that adds a date created on the first row, blank 2nd, then the header, and data. Is there a way to remove the first 2 rows easily?
Hi, As part of our integrating with Sisense, we require to be able to share dashboards programatically with groups. When I invoke the share action through the Sisense UI, I can see it's making a POST to /shares.The documentation only has GET request ...
Hey! Does anyone know how to:1. Know how to get rid of all the white space at the top of this widget? 2. Know how to widen the first column with the headers? 3. A work-around for the bug on the legend where it breaks anytime a filter is touched? Than...
I have the following code, but it is only searching on the second filter and not the first. { "style": "", "script": "", "title": "", "titleStyle": [ { "backgroundColor": "#093e52", "backgroundImage": "", "fontColor": "#093e52" } ], "showCarousel": t...
