0 Replies Latest reply: Jul 27, 2016 8:40 AM by Philip Radovich RSS

    First Sorted Value Issue

    Philip Radovich

      Hi,

       

      I created a bar chart 1 dimension and 2 Firstsortedvalue measures to pull in the first and last test scores for a performance indicator. When I don't have a person selected it is only showing the initial or the latest test value for certain items (first picture).The expression I am using for the Initial value is  FirstSortedValue(Value, AssessmentDate) and Latest value is FirstSortedValue(Value, -AssessmentDate). This works perfectly in my pivot table when no one is selected but not my bar chart. There is data available that it should be pulling in when nothing is selected. Once a user is selected measure fill in correctly (2nd picture). Could anyone tell what I am doing wrong or how to resolve this? Screen Shot 2016-07-27 at 8.33.24 AM.pngScreen Shot 2016-07-27 at 8.39.18 AM.png

       

      Thank you!