I have a measure that can be 0,50,70 or 100. When I filter on that measure's previous score=100 and current score less than 100, I only get 1 record (this particular record is correct) when I know I have many records that have changed in this way (based on a timeline report showing this measure's scores updated from 100 to a lower score on many records). Any nuances with these field types that I should consider or any idea why this is happening? I don't have a date filter or any other types of filters applied in addition to this one.
Solved
Report - Filters on current score and previous score don't seem to be working
+2Best answer by andy_roy
Hi Melissa. You may have already tried this, but I would probably remove that filter on previous date and include it as a "Show" field, just to look down the results and see what's there. Also, something I'm just now learning as I switch to Scorecards 2.0 is that current/previous scores are apparently tracked in a different place (MDA) than Scorecards "1.0" (Customer Info). Maybe that's related?
Hi Melissa. You may have already tried this, but I would probably remove that filter on previous date and include it as a "Show" field, just to look down the results and see what's there. Also, something I'm just now learning as I switch to Scorecards 2.0 is that current/previous scores are apparently tracked in a different place (MDA) than Scorecards "1.0" (Customer Info). Maybe that's related?
+2Hi Andy, I appreciate your reply! I will give that a shot. That doesn't solve for what I'm looking for though and now I'm not sure it's possible although it sounds so easy: a list of relationships whose score has declined.
I've also tried using the trend field breifly but could investigate that further.
I've also tried using the trend field breifly but could investigate that further.
+2Hi Melissa, this might be something where you'd want to get support involved. There are many variables with scorecards depending on how you have your measures set up and they can probably work through the precise objects and fields with you.
+2Thank you both. I think I solved it. The Previous Score field holds the score from the prior week, it's like a snapshot at the end of the prior week. That's why my report seemed to work on Saturdays and not on Mondays. I was under the impression Previous Score held the previous score regardless of when the change happened and set my filters accordingly.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.