Hi all,I would like to color the rows of pivot table in a gradient manner, based on the min value and max value of each row. By default, the conditional color formatting in sisense works at a column level.Thanks,
In Accounting, it is common to represent negative numbers with leading and trailing parentheses. For example, negative two hundred is displayed as "(200)" To change a negative number formatting in a pivot 2.0 chart - Add the following script to the p...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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)
What is the "Analyze SQL Query" section of the widget for? I can see its SQL however there are no recommendations or visualizations to show the execution or how to improve the query.There used to be a visualizer for the JAQL but that seems to be remo...
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...
