Line chart filter entire line based on end value

Ambrasegato — Sat, 16 Nov 2024 00:20:50 GMT

Hello everyone!

I am developing an app on Market share data for certain drugs and I have a line chart showing the Market Share evolution over time for each drug (each line represents a drug), as below

The request from the users of the application is to be able to hide the drugs that have a market share lower than a specific threshold (let's assume 2%) in the last period of the analysis. Ideally, the users should be able to change the threshold in the app with a slider.

I was able to calculate the share for the last period: Sum({<End_Date={"$(=Date(Last_Update,'DD/MM/YYYY'))"}>} value) but when I try to insert conditions on the last period share, then chart filters automatically on the last period only.

any ideas on how I could filter the entire line when the condition 'End period market share <= x%' is met?

topic Line chart filter entire line based on end value in App Development

Line chart filter entire line based on end value