Results 1 to 4 of 4

Thread: Compare values in one data set to range in another data set

Hybrid View

  1. #1

    Default Compare values in one data set to range in another data set

    I have a data set with values in it 81, 90, 93, 92, 84, 56
    I have a second data set with ranges grade low, grade high grade
    60 69 D
    70 79 C
    80 89 B
    90 99 A
    100 100 A+

    I was trying to use a lookup node.

    Any suggestions?

    Thank you

  2. #2
    Lavastorm Employee
    Join Date
    Apr 2014
    Location
    Boston, MA
    Posts
    279

    Default

    You can do a cartesian join here. Note that I have added a 0-59 range. Also note that if scores fall outside of 0-100, it gets dropped.

    You could also use a 'Band by Strata' node here. The only "tricky" thing is that the stratas start from -01 and end on -00 (instead of -00 to -09), so I adjusted the scores by one before banding.
    Attached Files Attached Files
    Last edited by ryeh; 06-13-2016 at 02:47 PM.

  3. #3

    Default

    As it is in version 5, I could not open with v6. Could you please provide some dumpscreen on it? Thanks!

  4. #4
    Lavastorm Employee gmullin's Avatar
    Join Date
    May 2014
    Location
    Chicago
    Posts
    185

    Default

    Here's the same graph saved in v5.1.

    GradeLookup_v51.brg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •