Combo Charts

[Gib Dreyer]

I am trying to copy this which is a dashboard we made using DevExpress. But there are several issues that we can not overcome.

SeeThe DevExpress chart attached

The first issue is that it does not combine columns A & B instead it places them on to separate charts that you have to scroll between.

But the main issue is the values of the Line going across the chart does scale appropriately with the bars which render it very difficult to read.

See The SyncFusion Combo Chart attached

Is there a way to fix this, or maybe an alternative chart that could be used to achieve a match to the DevExpress style chart?

thank you for your help.

Attachment: Chart_474789c3.zip

[Ranjani Ramalingam]

Hi Gib, 

Thanks for your interest in our Syncfusion Product. 

We are not able to reproduce the reported issue from our side. We are able to combine the column A & column B and we have added two line values to the Combo Chart Widget. Please find the below image. 

 

We have prepared a sample dashboard as per your screenshot and attached the sample sydx file for your reference in the below link. 

Sample Link: Sample 

Please check and let us know if you need any further assistance.  

Regards, 

Ranjani R. 

 

[Gib Dreyer]

Oh ok, I see, the problem is the way the data is entered into the database. that sample is exactly what we are looking for.

I attached a picture of the database and how it is structured. the problem is we do not have separate columns for each data set only a category entry for ether "Release" or "Booking". 

Is there a way to do that same chart in the sample you sent with the data in the format of the attached picture? 

thank you so much for your time.

Attachment: Chart_ef77a96f.zip

[Vinoth Krishnamoorthy]

Hi Gib, 

We have analyzed your data and found that your requirement can be achieved with the help of Expression Fields. Please find the below steps to achieve your requirement: 

1. Create the following expressions to get the actual and target values of Booking and Release.

Booking Actual - IF([Category] ="Booking", [Actual],0) 

Booking Target - IF([Category] =="Booking", [Target],0) 

Release Actual - IF([Category] =="Release", [Actual],0) 

Release Target - IF([Category] =="Release", [Target],0)  

2. Bind these expressions in Combo chart widget like below.

 

3. Disable the Secondary Value Axis property to hide Secondary Value Axis.

 

4. Now, you will get the expected result in Combo Chart widget. You can also customize the legend names if required.

 

We also prepared a sample dashboard for your reference, you can download the dashboard from the following link: 

https://www.syncfusion.com/downloads/support/forum/134880/ze/sample1030402611  

Please let us know if you need any further assistance.  

Regards, 

Vinoth K. 

  

[Gib Dreyer]

That is exactly what I was wanting. thank you very much for your time, you were very helpful.

[Ranjani Ramalingam]

Hi Gib, 

It's our pleasure, please do contact us if you require any other technical assistance. 

Regards, 

Ranjani R.