Is there is way to color some bars of a chart differently than others based on a time and date calculation, or some other calculations based on dimension values.
You can click on the + in front of a dimension or expression then click on Background color and enter an expression that calculates the color. if(MyField='A', green(), blue()). Read this blog post for example for more information.
Retrieving data ...