Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date picker and a chart that have one alternate state "StateA". I need the chart to react the same way to the KIC column selection. To do this, I wrote the following expression into the chart :
count({State1<KIC = $::KIC>} id)
But in this case, if no filters are selected, the expression counts only those id that have a value in the KIC column. That is, the KIC is not empty.
How to make it so that if there are no filters, the total value does not change. When adding KIC to an expression with an alternate state?
Example dataset:
HI
Try like below
If(GetselectedCount(KIC) = 0, count({State1} id), count({State1<KIC = $::KIC>} id))
HI
Try like below
If(GetselectedCount(KIC) = 0, count({State1} id), count({State1<KIC = $::KIC>} id))