The idea behind this one is that each customer may be given a series of 1-5 metrics to rank your company by (responsiveness, quality, etc) and that we will store those per customer and display each category averaged out. Use a bullet graph (https://www.fusioncharts.com/charts/bullet-graphs/) to present each of these categories. Ideally I would like this to be as dynamic as possible where we dynamically detect the categories based on the data and possibly even use columns in the queries to control the extents. The attached query was developed but we will still need to do some work with it to make it do that.
I completed this one. Note that the Fusion Charts bullet graph was not used, instead opting for using standard Bootstrap progress bars for better performance and simplicity.
The idea behind this one is that each customer may be given a series of 1-5 metrics to rank your company by (responsiveness, quality, etc) and that we will store those per customer and display each category averaged out. Use a bullet graph (https://www.fusioncharts.com/charts/bullet-graphs/) to present each of these categories. Ideally I would like this to be as dynamic as possible where we dynamically detect the categories based on the data and possibly even use columns in the queries to control the extents. The attached query was developed but we will still need to do some work with it to make it do that.