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 spider chart (https://www.fusioncharts.com/charts/radar-spider-charts/) 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.
aellis
commented
7 years ago
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 spider chart (https://www.fusioncharts.com/charts/radar-spider-charts/) 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.