Forum Discussion
How to resolve this improper filtering?
I have the following relationship diagram (link). The 2 non-date tables are linked by key (it's a region key) the left table is sales where every sale has a region key, and the right table is related to covid (which also has a key). When I do not filter, everything is fine. It show my sales from January 2020 to today and covid cases starting March to today. However when I filter for example on state, the only sales that are shown are from the day the covid cases started so start from March.
My goal is thus to have the filtering work but not that it only shows the date from March to April, but from January (starting date of sales) to April.
1 Reply
- AnonymousNot applicable
Anonymous
Can you show the visual you want to filter? Hide data if needed.I guess it is because there is no sales in the the state you filtered with, and the covid cases start march. So Jan and Feb are appeared as blank which is not showing on the visual by default.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.