Filtering data out of a straight table chart

[#1]

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]

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]

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'.