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...
Hello,Can someone tell me, what is the Default formula used to calculate Grand total in Pivot table widget.Thanks.
Hello, Is there a way to limit the number of bubbles displayed to only show a subset surrounding the selected data point?
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
Hi, I want to enable the functionality for my right widget (attached screenshot) to get filtered basis "cid_cm" selection in left pivot table.
