Forum Discussion
Anonymous
7 years agoNot applicable
Create line chart using filters based on another table
Hi guys, here is my situation: I have two tables 1. date 01/01/2019 01/02/2019 01/03/2019 ... 03/31/2019 2. company eff_date exp_date amount ...
Anonymous
7 years agoNot applicable
Sorry it's unclear in my statement.
I hope to create a line chart like this:
The y-axis is amount of inventory and x-axis is time. The point is that I have to create a measure to get the correct amount at the given time point. eg. at any given time T, the correct amount should be sum of amount with filter eff_date <= T & exp_date > T
I am stuck in creating such a measure.
Thanks!
parry2k
Super User
7 years agoAnonymous can you share sample data in excel file thru one drive/google drive?