0 Replies Latest reply: Jul 26, 2016 3:34 PM by Philip Radovich RSS

    Combine Measures

    Philip Radovich

      Hello,

       

      I am attempting to create a measure for test values based off the percentiles in the database. I am currently using the expression FirstSortedValue(Distinct Value, AssessmentDate) to pull in the initial test date. I am struggling though to write an expression where I can have Percentile based off the initial date above. I wanted to know if there is a way to combine the 2 in  a bar chart so the bar represents the percentile but when you hover it displays the initial date/value. Let me know if I can explain anything better.  The initial and latest measures are  based on the first sorted value expression above. I need the bar to be based on a field Percentile but for those measures.

      Screen Shot 2016-07-26 at 3.28.11 PM.png

       

      Thanks,

      Philip Radovich