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?
Forum Posts
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...
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: 20.21.6.10052I 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...
Count Unique Reference number based on Monthly data / date created and resolved date
Hi! I'm hoping someone would be able to assist me. I'm trying to create a formula that will calculate the number of unique reference numbers I have on a monthly basis.The conditions should be: For the Month of January 2023. 1. Calculate the number of...
Import Active Directory Data (Staff Names, Photos, etc) on Sisense Cloud
Can anyone direct me to a guide on what I need to do to import Active Directory data within Sisense Cloud?The only documentation I can find is here: https://docs.sisense.com/main/SisenseLinux/connecting-to-microsoft-active-directory.htmHowever that t...
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...
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...
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...
Change a widget basis selection in pivot table
Hi, I want to enable the functionality for my right widget (attached screenshot) to get filtered basis "cid_cm" selection in left pivot table.
Paldi plugin
Hi,We have few queries related to Advanced filter plugin usage along with viewer dashboard. We have around 5 submenu's in the viewer dashboard. We would need to show the filter only in specific submenu configured in viewer dashboard. Could you please...
Identify parent records that contain duplicate children (based on criteria in multiple columns)
Hello! I'm trying to identify the number of parent records that potentially contain duplicate child records, where "duplicate" is based on multiple fields.The parent is "Invoices", the children are "Line Items". Line Items are considered duplicates, ...
Button in Pivot table at the row level
Hi,Use case explained below: We have a specific set of dashboard requirements for which we're trying to do a feasibility analysis. Let's say we display call info in a table in a dashboard ; where each row corresponds to data of a call. Can we have a ...
