2 Replies Latest reply on Feb 15, 2013 1:25 PM by denno

    need help with chart sorting

    denno

      Title

      need help with chart sorting

      Post

           I have a database that is tracking ultrasound exams performed. One of the fields is ExamType. I am trying to create a chart that displays the number of scans of each ExamType performed, displayed from highest count to lowest.

            

           I have the Summary field:

           exam type count = Count of ExamType

            

           I have the Calc field:

           exam type count by exam = GetSummary ( exam type count ; ExamType)

            

           I created a chart with X axis of "ExamType" and Y axis of "exam type count by exam" with data point grouping enabled. When I have the records sorted by ExamType, the chart works but it's ordered by exam. I can't figure out how to sort "exam type count by exam" in descending order and have the chart display properly.

            

           Thanks!