Forum Discussion

Cloud Apps

08-11-2022

How to limit the values showed without altering values?

Hi, We have some scenarios when we need to calculate some metrics based on all the history. For example, contribution and more. We need to include several data to get the right value. But, for exam...

dashboards & reporting

harikm007

Data Warehouse

08-11-2022

Hi jirazazabal ,

If you need to get values from all dates, you can use ALL function (https://documentation.sisense.com/docs/function-references#all).

For example, to get total Sales Amount from all purchase date, use below formula

(SUM([Sales Amount]), ALL([Purchase Date]))

Is that what you are looking for?

-Hari

jirazazabal

Cloud Apps

08-11-2022

Hi harikm007

I've tried to do it, but in contribution, YTD... seems desn't work. I get en ERROR in the FOrmula when appling this calc, or I get no data in all the columns...

Thanks

Forum Discussion

How to limit the values showed without altering values?

Recent Discussions

Column Chart Break By Max No Series

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

Sisense

Support

Resources