Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering data out of a straight table chart

Hi all,

I have a very simple chart with 2 dimensions and 1 expression.

One of the dimenions is a field called 'TRUE_CLIENT'

I want to be able to filter out any records that have a TRUE_CLIENT of 'NONE'

How can I do this within the table?

Thanks in advance,
Matt

2 Replies
Not applicable
Author

you want to filter the expression to show records of TRUE_CLIENT of 'NONE'


= Sum( {$<TRUE_CLIENT={NONE}>} Value)

If you want to filter the dimension then you can use

=if(TRUE_CLIENT = 'NONE',TRUE_CLIENT_ID)
The problem is that it will return a blank row for all other clients, you can then select 'SUPRESS WHEN VALUE IS NULL' and this solves this problem


Another option is to place a marker when loading the data from the script

Table:
LOAD *,
if(TRUE_CLIENT = 'NONE', 'N_TRUE_CLIENT') as N_TRUE_CLIENT;
SQL SELECT *
FROM TABLE_ORDERS;

Now you have a new dimension called N_TRUE_CLIENT which you can use in your graph or report.

eric_dielessen
Partner - Contributor III
Partner - Contributor III

I think you need to do the following on the dimension tab:

  • Replace the dimension TRUE_CLIENT by a calculated dimension with following formula in it: =If(TRUE_CLIENT = 'NONE', Null(), TRUE_CLIENT).
  • Mark the checkbox 'Suppress when value is null'.