Help and How-To
Your place to get help using Sisense to meet your business needs
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Generic JDBC ClickHouse live model with custom dialect

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...

bryan by 8 - Cloud Apps
  • 1462 Views
  • 8 replies
  • 0 kudos

Resolved! How to calculate a cumulative unique count

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...

cjakerle by 9 - Travel Pro
  • 1594 Views
  • 3 replies
  • 0 kudos

Resolved! Dynamic POP Comparison on Dashboard

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...

Resolved! Counting by the Day of the Week in a Pivot Table

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 ...

dinda156_0-1717685495119.png
dinda156 by 8 - Cloud Apps
  • 1509 Views
  • 5 replies
  • 1 kudos

Resolved! Count two dates

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...

Resolved! Customization of YTD

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?

mgisp001 by 7 - Data Storage
  • 922 Views
  • 3 replies
  • 0 kudos

Resolved! How to remove headers on a widget

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...

Astroraf by 10 - ETL
  • 1041 Views
  • 1 replies
  • 0 kudos

Resolved! How to filter chart categories

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...

mosta2_0-1720199312903.png
mosta2 by 7 - Data Storage
  • 803 Views
  • 2 replies
  • 0 kudos

Community Content Spotlight

Content you missed that you never planned on reading

Updated: Feb 13th
  1. Blog: TreviPay’s Best Practice Journey
  2. KB Doc: Plugin – RemoveImageDownload – Removing Items From Sisense Menus
  3. Sisense Academy: Welcome to Sisense
  4. Sisense Docs: Explanations: Identify Reasons for Changes in Your Data
Check out our Software Developer Communities!