Hi,
We have couple of line series to be shown with Numeric Data on Y axis and Dates on X axis, we have data on daily basis and generally we have to display values for 1 year to 10 years as per user requirements. No user wants to view the data on Weekly, monthly or Quarterly basis, that some sampling function (First Value, Last Value, Min, Max, Average or any other Custom Function) should be applied to the data and when required or applied explicitly.
It is also called as Periodicity as well as sampling in different thrid party charting controls.
Is there any way to compact data in Infragistic Charts?
Thanks
Hello Imran,
I have been looking into your requirement and we have shipped a new Axis in 11.2 called OlapData, which is suitable for your requirements, but for the moment it is a CTP version and works with Column Series. It uses same Data as the XamPivotGrid. Here you can see a sample with it:
http://samples.infragistics.com/sldv/RunSamples.aspx?cn=data-chart#/data-chart/olap-axis
http://samples.infragistics.com/sldv/RunSamples.aspx?cn=data-chart#/data-chart/binding-olap-flat-data
In our next version(12.1), which is scheduled for April, there will be a functionality for choosing the Series type.
Your other option is to generate a different DataSource based on your data and the measure( average, max, etc.) applied to it and set it to the XamDataChart.
Hope this helps you.
Hi Stefan,
I am sorry that I am not able to provide any sample or screen short. It is very simple scenario,
assume daily financial data for 10 years showing about 2500 values,
now if a user wants to see the little high level picture then he may go for weekly view wich may show about 700 values.
and if user needs more high level view then he can select monthly view which may show 120 values and in simlar way Quarterly view may show 40 values while yearly view may only show 10 values.
In such case, it is required to use some compaction/sampling function to make a single value like first value, last value, max value, min value, average or etc.
Now if user wish to see weekly view with average then we may take average of all values in the week and then use it as single value.
Hope I have explained in details, but let me know if you need more details.
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking into your post, but it seems like I am missing something about your scenario, so if this is still an issue for you could you please send me a couple of screenshots of the different views you want to have, so I can think of a possible solution for you.
Feel free to write me if you have further questions.