NEWUX: Dynamic Time Period Filter based off Line Item Selected
I am building a chart where users can select a line item as a selector on the chart and the values will display over time. However there a many time periods currently showing for certain line items with no data. I would like a way to dynamically filter to show periods from the first period containing a non zero value to the last period with non zero data. The module has one hierarchical dimension (Available as a selector on the page) and time
The logic would be basically if this line item is selected than show periods from the first non zero period to the last non zero period . Not sure how to build this in the model or design in the newUX. Is there a workaround anyone has found?