Hello,I am using a Generic JDBC driver to query our ClickHouse cluster. It works quite well on ElasticCube, except for handling date types and date functions. Therefore, I would like to use a live model with a custom dialect. However, I haven't found...
This is a little tricky to explain. It's not just a running SUM from month to month. What we are trying to do is count the number of patients seen in a month, and show how that accumulates over time. The last tricky part is that we are hoping to h...
USE CASE: I have a dimension field - let's call it state that has 50 possible values but these change based on the data range selected. I'd like a bar chart with 2 columns # of Yes's and # of No's to break by each state into its own widget instead o...
Hello SisenseIs there a way to add database parameter {{}} inside an elasticcube B2D connection in Snowflake? Somehow it errors out in a B2D Snowflake connection but works well in live connection
Hi Sisense We are building a dashboard where user will be allowed to select from the following date scenarios Custom Range Current Week Last Week Current Month Last Month Last 3 Months Last 6 Months Last Year We are building KPI dashboard w...
Hello:I am attempting to count incidents by the day of the week across a month. I am hoping for: MON TUE WED THU FRI SAT SUNShift A 3 6 2 5 11 8 7Shift B 2 8 x ...
I have 3 columns DueDate, FinishedDate, ID What i want a metric of, is for a given time period, what is the ratio of finished date / due datebasically, in september, you had 40 records with a duedate in september, but only finished 20... the x axis d...
Hello everyone,I have a question on how to customize the YTD that is available when constructing a widget. I thought this was possible but now I'm not so sure. How would I go about getting the sum of the YTD between April-March versus Jan-Dec?
I created a line chart and the x-axis is ordered alphabetically, which is not what I want. How am I able to order it in a way that I want?
Please help how to remove the special character in text for policy owner name?
I have previously seen this post on the community regarding removing a header from a widget but the solutions have either been removed in terms of plugins or the code provided does not work. https://community.sisense.com/t5/build-analytics/remove-wid...
I am new to Sisense, trying to build a simple chart where categories from datamodel need to be filtered before usage in x-axis I understand it can be filtered by values but I want to filter the table based on another column in same table example : De...
I am using this script to create a hyperlink in a widget title but the hyperlink only shows in editing mode and not in the viewer mode. Trying to see what I can do to have this show in viewer mode as well. widget.on('refreshed', () => { ...
I am getting a warning trying to access the documentation site for Sisense...
I have two tenants (system tenant and a new one created).I believe that under: Admin > Security & Access > Single Sign On, the General configuration applies only for the system tenant (default one), however, I need to set up a different SAML 2.0 data...
