I have a pivot table listing out test taken. Currently it list all test taken but I only want to show the row if all three test have been taken. So if test A and test C have been completed but not test B then that persons data would be removed. If AB...
Does Sisense have text aggregate functions available to use for comparing text values? Some data fields require use of an aggregate function, but unable to identify a specific function to use in aggregating text values. Is there a function to allow f...
Hello, I was wondering if anyone had any ideas on how to save monthly instances of certain widgets, with their values. I have three widgets that are queried every night, and their values change accordingly. The dashboard that these widgets live on, h...
Hello,I'm relativly new in Sisense.Can someone please explain me how do I modify dashboard filters relationship?Thank you
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...
Hi Team,I want to custom sort the Pivot Column.See the screenshot attached.In the screenshot, I want to show particular manufacturer as first entry in the column and likewise.Please share the inputs.Thanks
When creating a column chart you might want to add a percentage value next to the actual value Add the following script to your widget: widget.on('processresult', function(widget,result) { result.result.plotOptions.series.dataLabels.formatter = fun...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Hi,I want to show the number of rows from a pivot table as a display number (like the numeric widget). How can I do that?
Hi Sisense community I have imported an excel sheet into my elasticube data model and would like to display the columns in the excel sheet in a pivot table in a widget. I do not want to aggregate the values from the Excel sheet using SUM() or COUNT(...
We have certain calendar-based metrics that need to be lagged (typically by 15 or 30 days). For instance YTD 2023, but excluding the last 15 days. I haven't been able to figure out how to do this within the basic filter selectors. It's almost lik...
Hi Guys,The requirement is that i have a dashboard need to access 2 different datasource.The 1st widget(table) is extract data from datasource 1, and there is a filter1: serial numberThe 2nd widget(table) extract data from datasource 2. and the 2nd t...
in a typical corporate data warehouse scenario, we'd have a wide range of facts covering different areas of the business. They in turn would likely be set up as different Elasticubes/models that have a small number of facts in each.However, it would...
Hi,Is there a way to export a table widget data using REST API?I haven't seen this option on the API documentation.
Does anyone know how to hide a column in a table widget? I saw the old post here (https://community.sisense.com/t5/build-analytics/pivot-2-0-hiding-columns-from-the-display/td-p/3607) for pivot table but that doesn't work on table widget. Thank you....
There are a couple of dimensional modeling patterns that you see out there, that I'm wondering if Sisense supports correctly.1. Snowflaking - (I don't mean Snowflake the database) - having rollup, lower-grain dimensions hung off of other more detaile...
