In the formatting options for the Pie Chart widget, under the 'Design' tab, you can choose to display various data labels on the chart. If you select either "Value" or "Category" then these will display outside the Pie Chart and will also display lit...
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...
