Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
When trying to hide an expression on a conditional statement - I find that if I put a 0 in the expression the rows are hidden, if I put a expression (such as =if(count({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>} distinct_row_key) > 0, 1 ,0)) the rows are displayed - even when the expression evaluates to 0.
So in the following table:
May-2011 | 22 | 0 |
Jun-2011 | 32 | 0 |
Jul-2011 | 59 | 0 |
Aug-2011 | 82 | 0 |
Sep-2011 | 122 | 0 |
Oct-2011 | 211 | 0 |
Nov-2011 | 299 | 0 |
Dec-2011 | 404 | 0 |
Jan-2012 | 525 | 1 |
Feb-2012 | 658 | 1 |
Mar-2012 | 827 | 1 |
Apr-2012 | 999 | 1 |
The rows from May-2011 until Dec -2011 should not show up - but they are.
Any ideas?
Try only({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>}1)
On second column use an "if" to return 0 and mark "Supress zero values" at Presentation tab
example (second column)
if(count({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>} distinct_row_key) > 0,
[second column expression]
,0))