13 Replies Latest reply on Dec 14, 2015 5:44 AM by Shinichiro Murakami

    Get value from row where <dimension> == <filter_bound>

    Christopher Berman

      I have a data set that looks like this:

       

      State    | Year | Value

      Alabama  | 1995 | 20

      Alabama  | 1996 | 25

      Alabama  | 1997 | 23

      Alabama  | 1998 | 26

      Alabama  | 1999 | 33

      Alaska   | 1995 | 8

      Alaska   | 1996 | 7

      [...]

       

      I've got a range of values filter on year, from 1995 to 1999, and this is all driving a filled map (which shows as color the sum of Value for the filtered range). I also want to show the Value for the lower bound year and upper bound year in a tooltip. In other words, if the filter currently is set to 1997 - 1999, I want the tooltip to display the Value corresponding to 1997 and 1999 (for Alabama, 23 and 33). Something like:

      _____________________

      | State:      Alabama |

      | 1997 Value: 23      |

      | 1999 Value: 33      |

      |_____________________|

       

      How can I do this?

       

      EDIT: Attached a minimal example of the data I'm working with

       

      Message was edited by: Christopher Berman