Forum Discussion
Solved
Remove filter in Query Editor
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 ...
- 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?
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?
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?