CODEWITHSUNDEEP
amchartsiccube-reporting
Bertrand Miot
Bertrand Miot

Reputation: 929

How to create combo graph with 4 measure series?

I have a graph I want to reproduce using IcCube reporting, (see example below)

enter image description here

I tried using AMChart combo chart type but without succes because there are 4 series of measures, I can do it when there are only 2 but did not succes with 4.

Could someone provide a working example ?

Upvotes: 1

Views: 204

Answers (2)

Arthur
Arthur

Reputation: 1704

A better solution is to use the standard Serial Chart. With the latest reporting version you can set-up axis that can be used by more than one measure.

This is how to do it:

  1. Create 4 Graphs, a graph for each measure
  2. Set the first two to Column, the 3rd and 4th to line
  3. Create 2 Value axis
  4. Set the 1st and 2nd measure to use the 1st Axis, the 3rd and 4th to the 2nd Axis.

2nd solution

In Live Demo / How To / Stackoverflow - Combo graph with 4 measures - 2nd solution That is it. All the rest is embellishment.

Upvotes: 1

ic3
ic3

Reputation: 7680

  • Create a combo Chart Create a MDX with 3 measures ( One for the bar values for both Nb 2016 and Nb 2017 -> Nb, one for 2016 Valorisation and the last one for 2017 Valorisation )
  • Add 3 Graph Configuration (two first one already exists)
  • Set the values of the 3 graphs to Nb, 2016 Val, 2017 Val and the chart types to column, line, line.
  • Use for the 3 graphs the default Value Axis.

This should do itenter image description here

In Live Demo / How To / Stackoverflow - Combo graph with 4 measure series

Upvotes: 1

Related Questions