Newest TopicsMost ViewedNo Replies YetNo Solutions YetSolutionsTagged:TagHow to pivot my data and get counts based on the min and max date value Morning Sisense community, I need to pivot my data and get counts based on the min and max date value. Given the below data: row date count Example 1/01/2025 35...How to filter a table/pivot table: Filter one column that does not equal another column? Hi DRay Liliia_DevX , I am trying to see if there is logic where I have a pivot table and I want to filter one column based on another column that do not equal, so getting all the results that ma...CASE WHEN logic in Formulas Hi DRay , I am trying to use the CASE WHEN logic in the formulas but does not seem to work. My logic: SUM(IF([Total DEFINITIVE_EST_NUM_OF_ER_VISITS]>0, [Total DEFINITIVE_EST_NUM_OF_ER_VISITS], ...Drag and re-order multiple columns at once Is there a way to drag and re-order multiple columns at once in a pivot table, rather than doing it one by one? Thanks How to increase the display more rows in Pivot Table? Hi, we have a need to display multiple rows in a pivot table widget, but it appears that there is a limit at 20, as the screenshot below the plus disappeared when reached to the limit. Is there ...SolvedNew Filter Regression Hi! This might be user error, but did we lose the ability to key in dates with the new filter UI? This seems like a major miss if so. Semantic Layer tables stack up like a deck of cards Hi All, About once a month, all of the tables in our semantic layer stack on top of one another. I'm not sure why. It takes me about an hour to put them back in their right places. Has anyone els...Resizing Sisense's Interactive Pivot dropdown menu Is there a way to increase the horizontal dimension of the dropdown menu for Sisense's Interactive Pivot Add-on? There are several metrics in the grocery space that are similar in nature, but higho...SolvedHow to display two different Values from two different years within the same month range? I want to display the Months from Jan to Dec. for two separate values. The image below shows what I am trying to achieve. I want a count for 2025 and I want a count for 2024. I have this my spread sh...SolvedDashboard (fire unit time limit) Hello, I am currently working in ESO (insights), and I wondered if anyone had any luck with making a dashboard that would display information like the one attached? It would be for certain apparat...How can I turn JAQL query into a SQL query? currently we are using JAQL to query data that we use to create some reports.. but now we want to get the same data by using SQL so I looking for a way to convert our JAQL queries into an equivalent ...How to create a filter within a widget? I know there are ways of creating custom filters with BloX, where we can pinpoint to a widget we want to affect but is there any solutions out there to have a filter WITHIN a widget? I provided som...SolvedIssue creating tables via POST/datamodels/{datamodelId}/schema/datasets/{datasetId}/tables Hello, When I create a table via the following endpoint: POST/datamodels/{datamodelId}/schema/datasets/{datasetId}/tables the table indeed is created, however the "preview of the data" an...Kamal Hinduja Swiss: How to use REST APIs to push data into Sisense? Hi All, I'm Kamal Hinduja, based in Geneva, Switzerland(Swiss) . Can anyone explain in details How to use REST APIs to push data into Sisense? Thanks, Regards Kamal Hinduja Geneva, Switzerland...Percentage in formulas Hello! I'm trying to work out how to get a percentage value in a formaula. The results are not what I'm expecting so i imagine it's my maths letting me down.. The end result needs to be a perc...Sisense Intelligence token estimation Hi. We are considering activating Sisense intelligence to use a LLM for our data models and dashboards. We want to estimate how much this would our organization from the LLM provider side. It de...Count (Boolean) I have segmented the sample and i have 5 distinct segments. We have recoded the segments with a (boolean) Yes or No. So the data is setup as Segment A = Yes/ no. I want to use the 123 indicator to di...Column chart with full range x-axis I'd like to create a column chart for which the x-axis always has values from 0 to 52 in increments of 1. The purpose of the chart is to show how many weeks of inventory remains at each distribution ...SolvedHow to target a specific cell/column to change the column in a pivot table? I have a pivot table where I am trying to turn the "Activity date for billable time" light green (can be any color) in my widget edit script, along with its corresponding value from another colu...SolvedHow to configure SSO with JWT I tried configuring SSO by going to Admin tab > Security & Access > Single Sign-On. I entered the following values: - Remote Login URL: https://reporting.mytestapp.com/sso - Remote Logout URL: ht...
About Help and How-ToYour place to get help using Sisense to meet your business needs543 PostsCreated: 2 years agoLatest Activity: 09-29-2025
