size frequency

4 posts, 0 answers
  1. nishan
    nishan avatar
    8 posts
    Member since:
    May 2015

    Posted 29 May Link to this post

    Dear Telerik,

    I am using pivotGrid and pivotFieldList

    I am having some size frequency data where all the sizes fall into different size classes. I want a continuous set of size classes but as no lengths exists for some size classes, I am getting gaps in the size classes.

    Please have a look at the attached files. You will see that the size classes are missing between 3 and 8 are more.

    Your help in getting a consistant continuous x axis is appreciated.

    Thanks,

  2. Hristo Merdjanov
    Admin
    Hristo Merdjanov avatar
    712 posts

    Posted 30 May Link to this post

    Hello Nishan,

    Thank you for writing.

    The displayed data in a chart associated with a RadPivotGrid directly relates the selected pivot data and this is the behavior by design. As a suggestion please consider modifying the underlying data so that you do not create missing values and have it running continuously. 

    I understand that his might not be possible so let me suggest you a different approach. You can try modifying the data source of the different series just after they are being created. For the purpose, you would need to create a custom PivotGridChartDataProvider and override its UpdateChartData method. Then you can read the current data points and add new ones to fill the empty values. I am sending you attached a sample project which should get you started.

    I hope this helps. Please let me know if you need further assistance.

    Regards,
    Hristo Merdjanov
    Telerik
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms.For more information check out this blog post and share your thoughts.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. nishan
    nishan avatar
    8 posts
    Member since:
    May 2015

    Posted 02 Jun in reply to Hristo Merdjanov Link to this post

    Dear Hristo

    Thanks for you example and guidance. Your code and the guidance to override worked.

    However, I realise that I will actually need to change the columns on the Pivotgrid to have these missing points. Can you please briefly guide me what I should do in order to add missing columns to the pivotgrid rather than the chart.

    Thanks,

     

    Nishan.

  5. Hristo Merdjanov
    Admin
    Hristo Merdjanov avatar
    712 posts

    Posted 07 Jun Link to this post

    Hello Nishan,

    Thank you for writing back.

    In order to display a particular field in RadPivotGrid as a column, for example, you would need to have this field within your data source object. As a suggestion please consider modifying your model so that you can bind the control and display the data in the format you require.

    I hope this helps. Please let me know if you need further assistance.

    Regards,
    Hristo Merdjanov
    Telerik
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.
Back to Top