Ignore all the filters - Blox

Comments

5 comments

  • Avatar
    Nathan Giusti

    For the second value, you could surround it with an ALL which will ignore the widget filters

     

    https://documentation.sisense.com/latest/creating-dashboards/using-formulas/create-formulas.htm#gsc.tab=0

    0
    Comment actions Permalink
  • Avatar
    Ryuji Morita (Edited )

    Hi Nathan. I appreciate your help. 

    Unfortunately, I have tried ALL function already and it didn't work in this case. Additionally, I would like to find a way to ignore the dashboard filter, not widget filters.

    Here are the code:

    and the result is below,

    0
    Comment actions Permalink
  • Avatar
    Satoshi Yokoo (Edited )

    Hi Ryuji,

    If you ignore the two filters, you can do the following.

    1.1st Value:

    (1)Define a formula
    sum([Unit])
    # Label name: "filtered"


    2.2nd Value:

    (1)Define a formula.
    (sum([Unit]),ALL([category_name]))

    (2)Click the Favorite (Star) button and enter as follows.
    "Total Unit All Category"

    (3)Defining a formula again.
    ([Total Unit All Category],ALL([customer_gender]))
    # Label name: "ignore 2filters"

    3.Blox Editor
    (1)2nd text block:
    "text": "500"
    -> "text": "{panel:filtered}"

    (2)4th text block:
    "text": "1000"
    -> "text": "{panel:ignore 2filters}"

    0
    Comment actions Permalink
  • Avatar
    Tanvi Bansal

    Hi

    I want to filter my dashboard when i click on the value in blox indicator. Is there any way to do it?

     

    0
    Comment actions Permalink
  • Avatar
    Nathan Giusti

    Tanvi Bansal

    You would use a clickable element action and for the type of action do dashboard filters. There should be snippets and examples in your blox widget.

    0
    Comment actions Permalink

Please sign in to leave a comment.