formulas

5 Topics

How to Filter Dates for a date that is greater than another date?
Hi DRay , intapiuser , JeremyFriedel I am trying to see the count of a column where the date from one field is greater than the date from another date. Here is my example: Table: Program_Plan_of_care_goal Field: Count (Goal_code) and Goal_actual_completion_date > Goal_target_completion_date I would assume I could achieve this with a CASE WHEN formula but this does not seem to get what I am looking for.
Solved
Astroraf
01-09-2026 Place Help and How-To
69Views
0likes
4Comments
Sort 'sdiff' results
I'm trying to figure out how to calculate the elapsed time between two data points in a record and then sort the results into different buckets. We use an embedded version of Sisense so I can't edit anything via the 'Elasticube'. I'm trying to take all the records created by a person and calculate the time from when the record was created to the time it was completed. Then display how many records were completed within different time frames. Either by using a column chart or pivot table. The problem is that the 'sdiff' function requires an aggregation. I don't want to find the median or average, I want to calculate the time for every record. I tried slapping an 'ALL' in front of the 'sdiff' function but that gave me an error. I also tried (COUNT(RECORDS),(SDIFF(ENDTIME, STARTTIME))) in the hopes that I could then filter the results but get an unexpected token error. I also tried CASE WHEN (SDIFF(ENDTIME,STARTTIME) < 7200 THEN 1 ELSE 0 END but ran into the same problem of 'sdiff' requiring an aggregator. What do?
EMS_Data_Guy
12-15-2025 Place Help and How-To
80Views
0likes
3Comments
How to have dashboard filters affect a formula filer?
Hi DRay , I have this formula in Sisense Bar Chart: (((([Total CLAIM_CNT]) )/([Total CLAIM_CNT],Prev([@Months in DATE], 12),([@Network Name])))-1) Where I have the Category being Network Name, I also have the Network Name in the Dashboard filter but when I select a Network Name in the Dashboard filter the widget does not filter for my selected Network Name. The Network Name being in the Denominator is to get the Total Claim Count. I also know that the hierarchy for filtering in Sisense is Formula Filter > Widget fitler > then Dashboard filter. Is there anyway to override this behavior? I still need to the overall claim counts to get the percentage by individual network names but still want to filter for the specific network name.
Solved
Astroraf
12-12-2025 Place Help and How-To
141Views
0likes
6Comments
Replacing values with text: Pivot 2 script
👋 Hello, I have clients doing this in Windows... Replace Values with Text - Pivot Table Widget | Sisense Align A Single Column In Pivot They might end up with a script like this: widget.on('ready', () => { $('td.p-value[val="1"][fidx="2"]').text("First-Time Donor") $('td.p-value[val="0"][fidx="2"]').text("Recurring Donor") }) widget.on('ready', function(sender, ev){ $('td[fidx=2]',element).css('text-align','left') $('td[fidx=2]',element).css('padding-left','5px') $('td[fidx=2]',element).css('vertical-align','middle') }); Can you help me convert this to Pivot 2?
Solved
wallingfordce
11-30-2025 Place Help and How-To
71Views
0likes
1Comment
Days between x and today
Attempting to create a formula that shows how long our requisition has been opened. I attempted with DDiff(requisition created date, todays date) but formula is unsuccessful.
Solved
hlister
07-21-2025 Place Help and How-To
141Views
0likes
3Comments