Line Chart - Empty Values and Month Sorting

3 posts, 0 answers
  1. Rasiel
    Rasiel avatar
    2 posts
    Member since:
    Jan 2015

    Posted 25 Mar 2015 Link to this post

    Hello there,

    I'm evaluating Telerik Reporting and I'm struggling with something that I know how to do in SSRS but I have no idea how to achieve it here.

    I'm using a line chart to show patient admissions trends for the last 6 months by payor type.

    Issues:

    1) I'm using Analysis Services as my data source, when I chose month as my category group, the months are sorted alphabetically. In SSRS I can reset the sort, and they will show in calendar order by default, but it seems that is not an option here. 
    I tried providing a user function for both grouping and sorting; but it doesn't seem to work.

    2) How can I handle empty values? I want empty values to be shown as "0". I found this http://www.telerik.com/help/reporting/featuresemptyvalues.html but I can't find where to set the EmptyValue properties nor how to get to the ChartSeriesCollection properties.

    Thanks in advance!
    R.
  2. Rasiel
    Rasiel avatar
    2 posts
    Member since:
    Jan 2015

    Posted 25 Mar 2015 Link to this post

    BTW - I forgot to mention that I'm using the 2015 Q1 version of Reporting.
  3. Hinata
    Hinata avatar
    146 posts
    Member since:
    Dec 2013

    Posted 30 Mar 2015 in reply to Rasiel Link to this post

    Hi Rasiel,

    Regarding first issue, when you insert a graph item using the wizard initially your axis scale will be category scale. This means the months will be interpreted as strings. If you try to sort those strings, they will be sorted alphabetically.
    To change the internal interpretation of the months you need to use a DateTime scale: How to: Change the Axis Scale. Then the sorting will be done in calendar order.

    Regarding the second issue, you can add a calculated field in your data source replacing empty values with 0: Calculated Fields.
Back to Top