Dashboard Action Different with Changed Data Types

[JanetBrewster1]

Hello All,

I have a working Dashboard, but recently did a data update that altered some functionality (I only need to update annually). Along with adding the new year's data, I changed some data types and field lengths for text. All the charts, indicators, and selectors work...except how the map adjusts to location selections. In my old version, when I selected locations, the individual areas on the map would appear, regardless of how many I selected. However, now, if I select more than one location, all the areas on the map show.

I've kept an older pre-update Dashboard for testing and can confirm that all the various details, Actions, etc. are the same between the two. Below are snippets of my fields, before and after, the first one being my new version.  I can't wrap my head around why a data type change would alter how the Dashboard works.

If anyone has suggestions why functionality would change, I'd love to hear it. Thank you!

[CodyPatterson]

Hey @JanetBrewster1 

I've had some dashboards change when moving from short to double previously. I'm no longer in a position I can test easily with, but would it be possible to try and convert the field one at a time and test with another backup of the previous dashboard?

I'm assuming that the select another location is probably throwing it into some SQL query, did that change at all? If it's something like "SELECT polygon WHERE <field> in ("some value", "null") it may select all locations that share that similar other value, I'm curious if this may be the case, I would check the selection fields on the two locations and see if there's anything that may point in that direction!

Cody

[JanetBrewster1]

@CodyPatterson 

Thanks so much, Cody! I appreciate the thoughts. It's helpful to know you had something go awry with a data type change, too.