Remove filter in Query Editor

[mafioso]

Hi,

I am currently adding a filter in order to get the rows I need. I want to divide the values of the relevant rows by 2. Everything works fine but I have no idea how to get back the data I had before adding the filter. I just can work with the dataset after the filter. Is there a way to get back all my data after dividing?

[GilbertQ · Accepted solution]

Hi there, if you put a filter into your data in a higher step, the only way to remove it, is to find the filter step and delete it.

In doing so will then show you all of your data without the filter. I would then complete your calculation and then possibly add the filter at the end.

It does sound like you only want to divide the values by 2 for certain rows. You could do this with a Custom column using an If statement?