Build Analytics
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Creating a Calendar Analytic with Time using BLOX

Hello,I am working on creating a schedule analytic in Sisense and will be mainly using Pivot Tables to do so. Aside from some additional row data added later, the screenshot below shows the information that will appear on the table. I would like to c...

ChesAsosa_0-1695820801079.png ChesAsosa_2-1695824784765.png
ChesAsosa by 8 - Cloud Apps
  • 0 replies
  • 0 kudos

Bubble Chart Limiting

Hello, Is there a way to limit the number of bubbles displayed to only show a subset surrounding the selected data point?

JoshG by 7 - Data Storage
  • 1 replies
  • 1 kudos

convert date time field to UTC format

Hello,I need some help around converting the date field column.I have a Customer response table coming from Redshift. The date time field is originally stored in UTC format.But when pulling it into Sisense, it is displaying in local timezone.I wanted...

lak by 7 - Data Storage
  • 3 replies
  • 0 kudos

2 events tied together by date filter

I have 2 type of data tables: assignments and completions. I want to perform the following formula.(# assigned_completions + # unassigned_completions) / (# assignments + # unassigned_completions)My elasticube has assignments and completions as differ...

Blox - Detailed List - pdf report only showing 1 page

Running version Version: have created a Blox widget based on the Detailed List template.It is the only widget on the dashboard.When viewed in the browser it displays many records. However when choosing the pdf report it only produces 1...

All days in date not working

I have a count of unique values and use (value,ALL(days_in_date)) function but is still being affected by my blox date filter. I need a way to calculate an all time formula for one column that is not affected by the date filter. Any ideas?This is wha...

zach_myt_0-1695157085200.png zach_myt_4-1695157276120.png zach_myt_3-1695157209455.png

GROWTH functions for indicators

Hi,I'm computing for change in metrics from period to period. For example, what's the pct change in sales from 2022 to 2023. Question 1: If data is only available until March 23 2023, will Growth functions compare 2023 data with 2022 data only until ...

Filter by Measure on clicking

Hi Team,I have a requirement where I have to filter by clicking on the bar chart and filter by the measure (value) and not the categories.For example:In the column chart below, when I click on the first bar, which has 876 number of ID's, I want other...


Blox Template

Hello I have got a requirement for the following1. Get an user input as a keyword(which is a word of the complete dimension)2. Add a search button3. The user input should be able to filter the dashboard(pivot) according to the entered part of the dim...

Syed_1313 by 7 - Data Storage
  • 0 replies
  • 0 kudos

Sisense pivot table conditional font color format

Hi All,Does anyone know of any script so that if the cell value is negative (<0), the font color in Sisense pivot table in all fields changes to red (#ff0000) but all other value formatting (such as %, decimal point and separator) in the fields remai...

magic_mic by 7 - Data Storage
  • 0 replies
  • 0 kudos

Pie Chart - High-Level Grouping by Type

We are trying, at a quick glance, to distinguish between records processed via automation vs those processed manually. For automation, we have approximately 11 different automated processes that may have last touched a record, with each process havin...

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]