Forum Discussion
Overlayed line chart
I am attempting to produce a line chart that produces data over the prior 12 month period (including current month) in monthly intervals. So currently it would be March 2017 - February 2018.
On this line chart I am trying to show data for 3 different actions on a specific record. Each record contains a dollar amount and a start date, then a majority of the records have a date that we can call the locked date and is always AFTER the start date, then about 60% of the records have a close out date (some records are still outstanding). The start date is always the earliest in the chain, then the locked date if there is one and then the close out date if the record is closed. The dollar amount associated with each record is always the same.
I am attempting to produce 3 lines on the chart for each date that moves across the trailing 12 month period - again in monthly intervals. I want to know the volume of records that started in each month, the volume of records that locked in each month, and the volume of records that were closed out in each month. But what I am getting is far from what I am looking for. Whatever date that I start with on the axis always calculates correctly. When I add the next dates in, it just does a cumulative total of the dollar amount for the entire population and displays that results for every month in my range.
I am sure I am missing something simple in my setup. Can anyone help me with a solution here?
1 Reply
- AnonymousNot applicable
pylesjos,
Please help to share dummy data of your table and post expected result here.
Regards,
Lydia