I have two graphs. One represents sales. The other represents inventory. I have these fields mapped to a canonical date such that they can be referred to on the same graph. Our business customer desires to have two separate graphs as we can show more information this way.
Sometimes there are sales or arrivals that occur beyond the latest date of the other field, ie one graph goes to 4/25/16 and the other to only 4/18/16.
I'm looking for a way to limit the X-axis (date) such that it only shows the smaller of the two (Largest available date). I've tried to do this in the expression but I think it's only capturing one date. I need to to be all dates up until the largest shared date.
Is there any easy way to do this? I've attempted it for a good couple of hours and can't seem to crack it.