Forum Discussion

Srav_Sense's avatar
Srav_Sense
Cloud Apps
11-04-2022
Solved

Ignore the Dashboard filter for one of the columns

I need to display a totals column, one in which the value should be filtered by the dashboard filter (date) and the other should the total value (ignoring the dashboard filter)

Customizations
Sisense Embed SDK
  • Harry's avatar
    Harry
    11-07-2022

    Hello Srav_Sense ,

    You can ignore a filter in formula using 'All' function.

    For example, if you want find total amount, but by ignoring date filter, the formula would be:

    (COUNT([AMOUNT]), ALL([DATE]))

    Note: the granularity of date in filter and formula should be same. i.e. If filter is showing months, 'Months in Date' should be selected in formula.

    Here is the documentation about the function: https://documentation.sisense.com/docs/function-references#all

    Please let me know if you have any questions

    Always here to help,
    Harry from QBeeQ
    [email protected]
    www.qbeeq.pl

5 Replies

Replies have been turned off for this discussion
  • Harry's avatar
    Harry
    Cloud Apps
    11-07-2022

    Hello Srav_Sense ,

    You can ignore a filter in formula using 'All' function.

    For example, if you want find total amount, but by ignoring date filter, the formula would be:

    (COUNT([AMOUNT]), ALL([DATE]))

    Note: the granularity of date in filter and formula should be same. i.e. If filter is showing months, 'Months in Date' should be selected in formula.

    Here is the documentation about the function: https://documentation.sisense.com/docs/function-references#all

    Please let me know if you have any questions

    Always here to help,
    Harry from QBeeQ
    [email protected]
    www.qbeeq.pl

  • Wojtek's avatar
    Wojtek
    Cloud Apps
    07-11-2023

    ALL function appears to have stopped working with new Analytical Engine enabled - im on L2023.2.

    Does anyone have an idea of alternative solution?

     

     

  • Wojtek's avatar
    Wojtek
    Cloud Apps
    09-19-2023

    zach_myt you could create dummy date rows as workaround but its not great , plus you would have to do it for all dimensions , not just date. If you try this or find some other workaround let us know 🙂