Radar chart with 2-level hierarchy

#1

What I want
A radar chart displaying a count per day of the week/hour, with both the day of the week and the hour in the chart.

What I get
A radar chart displaying either the aggregated count per day, or each point per hour (what I want) but the day name does not appear in the chart:
Screenshot%20from%202019-04-23%2014-23-40

What I have

  1. One hierarchy with 2 levels:
    a. dow which is a number (1 to 7) with as caption the actual name (Monday to Sunday)
    b. dowhour containing a ‘unique id’ (100 * dow + hour), with the actual hour as caption
  2. One data cube, giving out 3 columns
    a. dow (promoted hierarchy, matches the top level)
    b. dowhour (promoted hierarchy, matches the 2nd level)
    c. count (my actual data)

My final question
How can I get both levels of the hierarchy, thus hour and day on my radar chart?

Cheers,

#2

Hi Guillaume,

Radar chart axis labels are the same as for other chart types. Only the current level from a multi-level hierarchy is displayed initially, and you can drag specific levels onto Angular Axis Label to display a row for each level instead. Refer to the article here: https://www.dundas.com/support/learning/documentation/data-visualizations/visualization-tab-examples#h2-2-axis-labels

#3

Indeed, this is exactly what I was looking for. Thanks Jay!