Forum Discussion
Exclude certain Data
Assuming you have a Date field in your data set;
There are Visual Level Filters - so that in your visual, with that Date Field included - you can filter out the recently contacted with a Less Than parameter - this is in the visual design pane on right.
Or if you want to model your data at the table level - it can be done via Query Editor - perhaps make a No Contact Table - where you duplicate the core table but with a filter parameter in its definition.
Well I can exclude 2017 but it doesn't exactly give me what I want, because companies may have notes in 2017 meaning they were contacted in 2017. I really want to just get rid of the company from the report alltogether if they had a note anytime in 2017. Basically it would only show me companies that had a last contact date of 2016 but not higher than 2016
MFelix