Can anyone recommend the best-practice approach for defining each widget ID as its own variable so that I can reference the names in this script instead? I'm having a difficult time keeping each tab accurately updated. This is what I have currentl...
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.
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...
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...
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 o...
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...
Here is how you can include more information in tooltip. Steps: Create column/bar/line/area chart In this approach, result of disabled Values panel will display as additional information in tooltip . So create and disable Values panel as required....
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 @Angelina_QBeeQ ,I want to set color(red & green) of Rank cell based on Overall Vol measure.if Overall Vol>2000 then Rank cell will be Red else Green.Logic of Overall Vol is Count(call)
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 havi...
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...
Hi, I want to enable the functionality for my right widget (attached screenshot) to get filtered basis "cid_cm" selection in left pivot table.
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...
