Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have three expressions that each represent an individual score.
Can someone advise me as to how I put them on to a radar graph for comparison please?
I have had a go and it ends up looking like my 2 year old has colored in a circle!
Thanks,
Gareth
Gareth,
Expanding the expression was simply clicking the plus sign to view the expression properties or expand the expression. That's simply getting to the background chart color.
I guess it would have been helpful to send the actual app I created.
Have a look at the script here, this is where I did the cross table load.
Good luck!
Oscar
Gareth,
Can you provide some sample data and what expected results should look like?
Thanks
Oscar
Hi Oscar,
I've managed to create the radar graph eventually, fell lucky!
However, any ideas on how I'd color the area inside the data points depending on the score? Almost like a heat map
So for instance, on the attached, if a score is <79% is red, =79% and <85% is amber and =>85% green.
Thanks,
Gareth
Gareth,
You can have a look at what I've done here.
I've added a background color to the chart expression by expanding the expression. You will need to modify that to fit your needs, but this should give you a good starting point.
I've also modified the style of the chart.
Finally, I've changed your script slightly to do a cross table load of your data. The reason for this was to allow for a dimension to go along with a simple expression.
Have a look and let me know your thoughts.
Good luck!
Oscar
Thanks Oscar,
I understand the background chart color, but not sure what you mean by expanding the expression.
Likewise, I'm not sure what you mean by "Finally, I've changed your script slightly to do a cross table load of your data. The reason for this was to allow for a dimension to go along with a simple expression."
I do now have the below, which is progress!
Thanks,
Gareth
Gareth,
Expanding the expression was simply clicking the plus sign to view the expression properties or expand the expression. That's simply getting to the background chart color.
I guess it would have been helpful to send the actual app I created.
Have a look at the script here, this is where I did the cross table load.
Good luck!
Oscar
Thanks Oscar,
That's brill.
Thanks again,
Gareth