Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trouble with ColorMix1() on Bar Chart Colors

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?

Capture.PNG

0 Replies