Is anyone aware of options for conditional formatting of bar charts within reports? I am looking for the features typically found in Excel.
I have a rather lengthy, standardized (templated) report that includes probably 100 or so bar charts from multiple survey projects and questions. The bar charts all reference mean value as the metric.
I create unique published report links based on the "Company Name" data attribute. I then share these links in automated work flows so that respondents within the company can view real-time update results every time that response is submitted.
There are two manual updates to the master template that I need to make currently for each new company public link which I set up, which are time consuming. The first is sort the bars from left (highest) to right (lowest) mean values.
The second is to color the bars based on their relative mean values. The Report global visualization settings are not granular enough.
Any suggestions are appreciated!