Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got three expressions in my chart
if (Count (X) > 1, Count (X), '-')
if (Sum (XX) > 1, Sum (XX),'-')
if (sum (XXX)> 31, sum (XXX),'-')
I want to show only rows that qualify all the above expressions?
now i have for example:
X XX XXX
- 3 -
- - -
2 3 32
I want
X XX XXX
2 3 32
Daniel
Can you share sample data?
You can try this for your 3 expressions:
if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Count (X))
if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XX))
if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XXX))
or you can try a calculated dimension like:
aggr(only({<YourField = {'=Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31'}>}YourField), YourField)
then with expressions:
count(X)
sum(XX)
sum(XXX)
Hope this helps!