Post reply

Pie Chart with Date Ranges

  • February 16, 2012 at 2:55 pm

    #255914

    Hi, I'm fairly new to SSRS and am struggling with how to get my data presented in a pie chart correctly.

    I have aquery that returns 2 columns, 1 contained machine names and the other containing the date that inventory was last returned. I want to have a pie chart that is split showing the % that returned inventory in the last week, last month and more than a month. What's th ebest way of doing this in SSRS 2005? Many thanks for any advice.

  • February 17, 2012 at 3:32 am

    #1448380

    Think I've sussed it, basically add an extra field assigning a number value for each range I want and use that for the pie data.

  • February 17, 2012 at 7:26 am

    #1448491

    That would be the best solution. Solve the grouping within the SQL Query that you use as a source for the report.

    Don't forget to exclude (subtract) the last week's inventory from the last month's so you won't count anything double.


    My LinkedIn profile

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply