• Replies 4 replies
  • Subscribers 336 subscribers
  • Views 37 views
  • Users 0 members are here
Related

T-Stats Postal Code

Leslie McKinley
$organization

I love using T-Stats for easy Pivot tables.  My go-to use is for Postal Codes and Geo Area.

Recently though I was doing a simple count for Zip Codes with a list of 108 constituents.  T-Stats only reported back 61???

I did look at the drop for the T-Stat element and clearly it did not have all the possible zip codes.  Is there a rountine "refresh" that supposed to be done so T-Stats can report back on the actual data?

 

Thanks

 

 

  • $organization

    There should be a nightly job to update the cubes. Have IT guys look into it.

    Travis

  • $organization

    Thanks --- I can confirm this must happen since I tried the same report (sane or insane) last night and it worked beautifully.  Good to know

     

    From: Travis Armbuster [mailto:bounce-travisarmbuster9061@tessituranetwork.com]
    Sent: Friday, June 03, 2016 6:09 AM
    To: McKinley, Leslie <LMcKinley@nycitycenter.org>
    Subject: Re: [Tessitura Technical Forum] T-Stats Postal Code

     

    There should be a nightly job to update the cubes. Have IT guys look into it.

    Travis

    From: Leslie McKinley <bounce-lesliemckinley4321@tessituranetwork.com>
    Sent: 6/2/2016 10:32:26 AM

    I love using T-Stats for easy Pivot tables.  My go-to use is for Postal Codes and Geo Area.

    Recently though I was doing a simple count for Zip Codes with a list of 108 constituents.  T-Stats only reported back 61???

    I did look at the drop for the T-Stat element and clearly it did not have all the possible zip codes.  Is there a rountine "refresh" that supposed to be done so T-Stats can report back on the actual data?

     

    Thanks

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization

    Hi Leslie,

    Jumping in to mention you may get more responses in the future if you post this type of question in the T-Stats forum rather than the general technical forum.

    As it sounds like you've observed, T-Stats is refreshed overnight so  a newly-generated list may contain constituents not yet loaded into T-Stats, but who would be present after the next refresh. This article also goes into some additional details that may be of interest. 



    [edited by: Amanda Freeman at 1:31 PM (GMT -6) on 6 Jun 2016]
  • $organization

    Amanda  -- Thanks – I didn’t see the T-Stat forum so good to know it’s there – will note for future.    Glad I asked though since our new IT person learned something too. – thanks for taking the time to add this info.  - Leslie

     

    From: Amanda Freeman [mailto:bounce-amandafreeman5080@tessituranetwork.com]
    Sent: Monday, June 06, 2016 1:38 PM
    To: McKinley, Leslie <LMcKinley@nycitycenter.org>
    Subject: Re: [Tessitura Technical Forum] T-Stats Postal Code

     

    Hi Lesley,

    Jumping in to mention you may get more responses if you post this type of question in the T-Stats forum rather than the general technical forum.

    As it sounds like you've observed, T-Stats is refreshed overnight so  a newly-generated list may contain constituents not yet loaded into T-Stats, but who would be present after the next refresh. This article also goes into some additional details that may be of interest. 

    From: Leslie McKinley <bounce-lesliemckinley4321@tessituranetwork.com>
    Sent: 6/2/2016 10:32:26 AM

    I love using T-Stats for easy Pivot tables.  My go-to use is for Postal Codes and Geo Area.

    Recently though I was doing a simple count for Zip Codes with a list of 108 constituents.  T-Stats only reported back 61???

    I did look at the drop for the T-Stat element and clearly it did not have all the possible zip codes.  Is there a rountine "refresh" that supposed to be done so T-Stats can report back on the actual data?

     

    Thanks

     

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!