Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a question concerning definition of axes in a radar chart. I've got 5 categories I want to display as axes. Furthermore I've got lots of data (e.g. companies) for which I have specific values for each category.
By now I structured my data the following way to build the radar chart.
Used Dimensions for the Chart are: Category and Entity
Used Expression is: only (value)
Example:
Entity Category Value
A Dimension 1 1
A Dimension 2 3
A Dimension 3 5
A Dimension 4 2
A Dimension 5 3
C Dimension 1 2
C Dimension 2 5
C Dimension 3 5
C Dimension 4 3
C Dimension 5 4
Is it possible to build a radar chart like the one above, without multiple lines of categories for every entity, with a data structure like the one below?
Entity Dimension 1 Dimension 2 Dimension 3 ...
A 1 3 5 ...
B ... ... .... ...
C 2 5 5 ...
Hope someone can solve my problem....