Forum Discussion
Filter Specific Data from different Timeperiod, without changing Timeperiod
Hello everyone,
- i have a summed revenue from the last 4 Calenderweeks displayed as a linegraph
The Filtering in 4 last Calenderwek is done by "Filter-on-Visual level"
- and revenues by productcategories but only the last week as Columngraph
The Filtering of last Calenderwek is also done by "Filter-on-Visual level"
- If i filter by a productcategory, it also filters the timeperiod of the linegraph of (last week - shown as a dot) instead of only filtering by the productcategory
Linegraph of only last week
i tried all() filters, and searched for a solution on several forums, but their solutions doesnt seem to fit to my problem
how can i keep the linegraphs "last 4 weeks" filter
i got the Solution on my own:
The problem was the Last Calenderweek "Filter-on-Visual Level" in "productcategory", i made a Measure with last Weeks Revenue explicitly for the productcategory visual and deleted the Filter-on-visual level.
If i crossfilter now by a certain productcategory, the linegraph gets only filtered by that productcategory
2 Replies
Change the interaction mode from crossfiltering to crosshighlighting, or disconnect the tables and use measure filters instead.
i got the Solution on my own:
The problem was the Last Calenderweek "Filter-on-Visual Level" in "productcategory", i made a Measure with last Weeks Revenue explicitly for the productcategory visual and deleted the Filter-on-visual level.
If i crossfilter now by a certain productcategory, the linegraph gets only filtered by that productcategory
