calculation condition or other filter ?

[#1]

Hello,

I have a table with columns : code_project (text), date, num (number), action (text),  state (=1 or null).

I created one list box (to choose code_project) and one chart (number/date, no matter the state), and i want to add a table to show actions for the code_project selected, with state=1.

I tried with a Table box, with Calculation condition : state=1

but it does'nt work (if I add a list box on state and i select value 1, the table box is ok, but it is the chart which is not, because filtered !)

How to do correctly ?

Thanks !

Vincent

[lironbaram]

you can add to your chart expression set analysis {<state=>}

so the expression in the chart will disregard selection in the state field

[#3]

I don't use a chart, but a table box, without "expression" tab, but with a "Calculation condition".

And if i try with a "straight table" chart, nothing appear...

Sorry, i'm a beginner, can you explain a little more ?

Thanks !

Vincent

[#4]

I have same issue but problem is that like yours when putting condition my data is limited to 2 million from 30 million. And with straight table it takes around 30GB RAM for 2 million rows and table box takes 1GB for 30 million rows.

did you find any solution