I have 2 bar charts, tracking 2 different things - one is a "letter sent" chart, and one is a "payment sent" chart.
Both of these charts measure pretty much the same thing: letters must be sent out within 60 days of receiving them, and payments also must be sent out within 60 days of receiving them.
These are all linked to unique ID's. so, for instance: ID number 1234 has a record on the payment bar chart. It also has a record on the letters bar chart. They were both handled in a timely fashion (sent out within 60 days of notice to send), and all is well.
If we have 100 different ID's, and they all were sent in a timely fashion, the bar chart shows 100% for that month.
Now, here's the question....
I need to make a bar chart which only shows the WORST of these results. For instance, in the month of October, if we were at 100% for the letters, but only 90% for the payments, the bar chart should only show the 90% for the payments.
The user only wants to see the worst results for that month.
Is there a way to do this? Perhaps make a 3rd chart, which says to take the lowest percentage of the 2 charts I have, based on month?
Or can I do all of this behind the scenes, and only show the one chart with the "worst results"?
Hmmm.... now that I think about it, I might have to do these in a chart only, not in a loading of tables.
Let me ask you this - is it possible to do 2 expressions in the chart (showing my "letter" and "payment" bars for each month), and then somehow tell the chart to only show the lowest value/bar for each month, and "remove" the other?
That would completely solve this issue for me, if there's a way to do this.