-
1. Re: Filtering Data and imputing dates
Jim DehnerAug 14, 2019 4:49 AM (in response to Jason Focho Tarimo)
here is an example using superstore furniture sales
then create a filter
place it on the filter shelf and set to true
and you get this
without the filter it is this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Filtering Data and imputing dates
Jason Focho Tarimo Aug 14, 2019 4:55 AM (in response to Jim Dehner)Hi Jim,
I am not sure that quiet solves the question.
What i want is to filter out a certain number from a numerical variable ( not categorical). For example i want just the number 2000 omited from my profit variable.
How can i go about that?
-
3. Re: Filtering Data and imputing dates
Jim DehnerAug 14, 2019 4:58 AM (in response to Jason Focho Tarimo)
I understand
but since you did not share your twbx workbook I had to make up something to show you that you can use filters to on a calculated field value -
if you have a twbx workbook please post it and I will show you how in your data
JIm
-
4. Re: Filtering Data and imputing dates
Jason Focho Tarimo Aug 14, 2019 5:12 AM (in response to Jim Dehner)1 of 1 people found this helpfulJim,
I have a numerical table of values 1-5000 for example. These are numbers and not categories and i want to filter out the value 2000. How can i go about that.I just need a calculated field to that for me.
-
5. Re: Filtering Data and imputing dates
Jim DehnerAug 14, 2019 5:17 AM (in response to Jason Focho Tarimo)
Jason
try sum(Profit)<>2000 as a filter and set to True
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.