• Replies 8 replies
  • Subscribers 959 subscribers
  • Views 301 views
  • Users 0 members are here
Related

Postcodes in Analytics

Former Member
Former Member $organization

I was trying to look at members by (short) postcode, and I built a pivot table that shows that information (Count of Constituent IDs in values, Primary Address Postcode Short in rows, with a widget filter limiting to six Primary Address Postcode Short selections and dashboard filters limiting to several Membership Levels and Current Status in active or pending). I then copied the pivot table and changed the widget type to a scatter map. But the scatter map shows a smaller number of memberships in each postcode than the pivot table shows, and the scatter map does not seem to respect the Primary Address Postcode Short filter that I have on the widget limiting it to only 6 postcodes. Is there a way to filter the scatter map ? And why is it showing different counts for each zipcode? Is it because it's not including 9-digit zip codes? (So 20002-1234 isn't getting included in 20002, for example?)  Thanks!

Leslie Gehring

Parents
  • $organization

    I too have seen counts that I can not explain in scatter maps.  (I've not reported this in a Support Ticket, I've got, other more important issues open with support right now.)

    My sense (and this is only anecdotal), is that:

    • the scatter map may have some undisclosed limit on the number of postal codes that it can display. For example, if I try to map all members ever in my system, things start to get sketchy, in some of the same ways you are describing here.
    • I've also got the sense that you have to include Country, State, City and Zipcode in the geographic area to get it to display correctly.  

    Again both of those are very incomplete report backs.  Would love to hear more about your findings.  And if you have not put a support ticket in, I encourage you / your organization to do so.  I know that the Analytics team is actively working on squashing a few bugs right now for upcoming Service Packs.  And the sooner we can surface issues the sooner all of us can reap the benefits of a smoothly working Tessitura Analytics.

    Thanks for sharing, hope that's a bit of help.  

    P.S. if you would like to share a .dash file here, I'd like to see what you are doing.  (.dash files don't share data, they share the setup of tessitura analytics dashboards.)

Reply
  • $organization

    I too have seen counts that I can not explain in scatter maps.  (I've not reported this in a Support Ticket, I've got, other more important issues open with support right now.)

    My sense (and this is only anecdotal), is that:

    • the scatter map may have some undisclosed limit on the number of postal codes that it can display. For example, if I try to map all members ever in my system, things start to get sketchy, in some of the same ways you are describing here.
    • I've also got the sense that you have to include Country, State, City and Zipcode in the geographic area to get it to display correctly.  

    Again both of those are very incomplete report backs.  Would love to hear more about your findings.  And if you have not put a support ticket in, I encourage you / your organization to do so.  I know that the Analytics team is actively working on squashing a few bugs right now for upcoming Service Packs.  And the sooner we can surface issues the sooner all of us can reap the benefits of a smoothly working Tessitura Analytics.

    Thanks for sharing, hope that's a bit of help.  

    P.S. if you would like to share a .dash file here, I'd like to see what you are doing.  (.dash files don't share data, they share the setup of tessitura analytics dashboards.)

Children
No Data