column line chart to measures using the same axis

Answered
Craig Button asked on May 12, 2023

Hello,
How can I make make two measures use the same axis, e.g. the attached. when using the pivot charts.
 
Kind regards,
Craig Button

5 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 12, 2023

Hello, Craig!
 
Thank you for contacting us.
 
We noticed that no attachments were included in your message. could you please resend the attachments to us?
 
Speaking about multiple measures on the same chart, it is possible to enable multiple measures for the following chart types:

  • column
  • bar
  • line
  • scatter

 
Multiple measures can be enabled via the UI as the last checkbox in the Charts dropdown.
Also, it can be configured programmatically by setting the multipleMeasures option to true:

report: {
 //other report configurations
 options: {
      chart:{
        type: "line",
        multipleMeasures: true
      }
    }
}

here is the JSFiddle sample of the line chart with multiple measures: https://jsfiddle.net/flexmonster/wevu9f24/.
 
Hope you will find our answer helpful. Please let us know if there are any further questions.
 
Kind regards,
Solomiia

Public
Craig Button May 15, 2023

Thanks Solomiia,
I'm looking to create a bar line chart like the attached (hopefully should be attached this time) programmatically. You'll see it only has one Y-axis.
If I create a bar line chart in Flexmonster however, the bar and line use a different Y-axis for its value which isn't quite right for the data we are trying to show.
I hope this is a bit clearer.
 
Kind regards,
Craig Button

Attachments:
mockgraph.png

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 15, 2023

Hello, Craig!
 
Thank you for the detailed explanation of your use case.
 
Kindly note that in the column line chart, there would always be two Y-Axis as it displays two different measures.
 
It is possible to create charts with multiple measures and common Y-axe using our integration with 3rd party charting libraries. Please find more information about it in our docs: https://www.flexmonster.com/doc/available-tutorials-charts/#3rd-party-charts.
 
Hope you will find our answer helpful.
 
Kind regards,
Solomiia

Public
Craig Button May 15, 2023

I thought that might be the case.
Thanks for your help Solomiia.

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 16, 2023

Hello, Craig!

Thank you for your feedback.

Feel free to contact us in case of any other questions.

Kind regards,
Solomiia

Please login or Register to Submit Answer