Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where I'm trying to restrict rows and enabling conditions doesn't seem to do the trick for me. I can simplyfy the data for the purpose of an example here.
status | sum(lead_count) |
---|---|
Accepted | 1416 |
Review | 37 |
Ineligible | 193 |
Declined | 186 |
Pending | 1 |
If I have the data above, and I only want to show rows where the lead_count > 1, how would I do that? I tried to enable a lead_count > 1 condition within the dimension and expression, but neither technique worked. Any help would be appreciated.
Thanks.
You can use a calculated dimension: if(aggr(sum(lead_count),status)>1,status)
or a set analysis expression: count({<status={'=count(lead_count)>1'}>} status)
or you can use Dimension limits and use the option Show only values that are Greater Than 1 exact amount
See attached example.
You can use a calculated dimension: if(aggr(sum(lead_count),status)>1,status)
or a set analysis expression: count({<status={'=count(lead_count)>1'}>} status)
or you can use Dimension limits and use the option Show only values that are Greater Than 1 exact amount
See attached example.
Thanks! That worked.