If I understand correctly, you need to show median values for different date ranges depending on the type of date - First Contact, Application, Completion etc.
Do you need to be able to select a date range for each of these 3 types of dates and then show the three median values?
Right now you have a line chart for each median value by month for different date types. I think what you are showing is the median of median values by month in each chart. Is this what you are trying to show?
Can you clarify?
2 of 2 people found this helpful
If I understand your predicament, this is a frequent issue.
There may be several paths to a solution, however.
If you have control over your data, you might try restructuring it so you have a single [Date] dimension and a single [Date Entry Type] dimension. You can very easily plot your multiple lines using the [Date Entry Type].
Another option you might try is linking your dates to a Master Date file, and then using that all-encompassing dimension to "rule them all," so to speak. You can find details of that here, but frankly my head gets a bit wibbily-wobbly after too much:
Here's another example that may be a little easier to download and look under the hood. Some of the bells and whistles you may not need:
One last place you can check (and this looked promising, at least at first):
Thanks Michael, at least I am happy to know that what I had been struggling with for hours is not something easily achievable! I had wanted to use the data source without restructuring however it does seem that it is the easiest course. Thanks for also suggesting that extra light reading...will go through those sites too.
Please don't give up yet-- give the Zen Masters here a moment or two and they may have a solution for you that doesn't require the use of aspirin!
Ok great, thanks Michael...fingers crossed!