1 of 1 people found this helpful
Morning Zach, you've hit on one of the features that is greatly improved in 7.0! In 6.1 you're dealing with this:
And there's not really anyway to get a nice clean orange. In 7.0 when you click the start box at the end of the color range you get this:
Which results in this:
Which of course is what you're looking for. Unfortunately that means upgrading to 7.0 which probably isn't an option for you since you haven't done it already. I've studied your workbook and can't figure out why the color string is throwing off the values in your chart. I can't even see a pattern to it and I can't get at the Measure Value shelf, so I really don't know what's going on here. Hopefully someone else will have an answer for you. Sorry dude.
Thanks Shawn, we're about to go to 7, the color selection looks much improved.
I just figured out that my calculated dimension needed to aggregate the daily records using SUM so as to not partition the data. So I changed from IIF([Minutes_FH-GP]>0, "FH","GP") to IIF(SUM([Minutes_FH-GP])>0, "FH","GP") to do the calculation per day rather than per record. Now it works. Updated screenshot and workbook attached.
average_delays_zl2.twbx.zip 97.6 KB