Hello Support team.
i have subscribe Infragistic LightSwitch control 11.2
I am using Data Column Chart for displaying 3 values.
1. TotalPaidAmount
2. TotalBalanceAmount
3. TotalUnpaidAmount
The thing is when i integrate a Column chart to displaying the above values, it displaying all the values including the number of invoice generated.
I want total three column in the chart control. But it displaying three column for each invoice.
From the above image you can see there are 8 nos. of invoices. In right side you can able to see the chart which displaying the result for 8 no. of invoices.
But i want it should show one result.
Please help me in this regard.
Thanks
Hi Rashmi,
I'm looking into this issue for you and will get back to you tomorrow.
The Infragistics data chart currently only supports binding to a table and not the selected item in the table. Based on your description what your looking for is that the user selects an entry in the grid on the left and the chart on the right updates to reflect the new selection.
What you can do is use the Infragistics Bullet Graph assigned to your table's SelectedItem property. The bullet graph can be aligned vertically or horizontally to function the same as a bar or column chart. The downside to the bullet graph is that you will need three of them to represent your particular values since the bullet graph can only show 1 value at a time.
I have attached a sample showing how you can use the bullet graph. Let me know if you have any questions.
Hi Rob
Thanks for your reply
But, As you mention
"Based on your description what your looking for is that the user selects an entry in the grid on the left and the chart on the right updates to reflect the new selection."
Its sorry to say but, I think you do not understand my query
I don't want to change the chart value depending upon left hand side grid. I want to display only three properties (i.e. TotalPaidAmount, TotalBalanceAmoun & TotalUnpaidAmount), but when i am binding these properties (Computed) to chart its showing the result depending upon no of invoice present in the left grid.
I want only three bar for the above three computed properties. (It should not depends upon LHS grid).
In order to display just those three properties, the data source that the chart is bound to needs to only contain one item with those three properties.
I would first create a new data source and add the properties to it. Then in the screen add a data item using the 'Add Data Item....' menu. In the 'Add Data Item' dialog, select Query then select the data source that was just created. Make sure it's the one with the (All) return type or else you won't be able to bind it to the data chart. Click 'Ok' and create the Infragisitcs Data Chart bound to the new data item. Now in code you can add a single item to the data set with your calculated values and the chart should display one set of values. I updated my sample to show this.
Let me know if you have any questions on this.
Thanks for your support
Now its working fine.