Forum Discussion

ETL

02-15-2023

RSUM not producing desired result when filtering

I've built a widget that uses RSUM to sum the values for multiple rows/RSUM of Fiscal Period of Year as shown in column Avg YTD Revenue shown in the two screen shots below: Works great. How...

dashboards & reporting

Angelina_QBeeQ

ETL

02-16-2023

Silutions ,

Okay, you can try another option. Check if the Analytical Engine is enabled.
If so, deactivate it (https://docs.sisense.com/main/SisenseLinux/activating-analytical-engine.htm) and check the calculation with all() function.
But it takes some time for the changes to take effect.

Kind regards,
Angelina

Silutions

ETL

02-16-2023

Angelina,

Good suggestion, but we have already made the decision to leave the Analytical Engine enabled.

Regards, Jim

Forum Discussion

RSUM not producing desired result when filtering

Recent Discussions

Pivot Table widget - column headers and column data out of alignment

Blox conditional formatting up and down indicators

Remove Widget Title Box

Change Legend Category Names

Rename the Pivot Grand Total

Sisense

Support

Resources