Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Text Aggregate functions

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...

Resolved! Displaying Monthly Changes

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...

Resolved! Filters relationship

Hello,I'm relativly new in Sisense.Can someone please explain me how do I modify dashboard filters relationship?Thank you

George by 7 - Data Storage
  • 1583 Views
  • 2 replies
  • 0 kudos

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...

lak by 7 - Data Storage
  • 1769 Views
  • 3 replies
  • 0 kudos

custom sort pivot column

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  

zohebakber_0-1690366086947.png

Bar Chart - Add Percentage to the Value Label

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...

Ophir_Buchman_0-1650452574643.png Ophir_Buchman_1-1650452595480.png 83227784_3726975083979609_8570336295451099136_n[1].jpg

Adding a column with no aggregation

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(...

amelia by 10 - ETL
  • 5554 Views
  • 7 replies
  • 0 kudos

Resolved! Date filters - possible to have fixed start date, lagged end date?

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...

green by 8 - Cloud Apps
  • 1572 Views
  • 5 replies
  • 0 kudos

Resolved! How to synchronize 2 filters

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...

benson_lv_0-1697617100780.png
benson_lv by 8 - Cloud Apps
  • 2819 Views
  • 8 replies
  • 0 kudos

Resolved! "Reusable cube" for dimensions

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...

Resolved! Exporting CSV using REST API

Hi,Is there a way to export a table widget data using REST API?I haven't seen this option on the API documentation.

TomerA by 8 - Cloud Apps
  • 10827 Views
  • 10 replies
  • 1 kudos

How to hide a column in a table widget?

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....

DXC by 8 - Cloud Apps
  • 3878 Views
  • 7 replies
  • 0 kudos

Modeling patterns

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...

Check out our Software Developer Communities!