Trouble with ColorMix1() in Bar Chart colors

[#1]

I'm trying to use a bar chart to show how blog posts per category were published, and what the relative views per post value is. From the Colormix Wizard and some tutorials I have the following expression set up.

ColorMix1 (

(Sum (#pageviews)/Count ({$<_published = {1}>} DISTINCT post_title))

/(RangeMax (top(total Sum (#pageviews)/Count ({$<_published = {1}>} DISTINCT post_title),1,NoOfRows(total))))

, Red(), Green())

I've used this on both the text color and the bar color. It is working perfect for the text color, but in the bar color a 1 is returned for all rows, making everything solid green. Any suggestions?

[stigchel]

For the bar colors did you do this in the color tab of the properties or in the background color option of the expression?. It should be the last, calculated colors in the color tab are not evaluated over the dimension(s).