Query by country-code does not show all countries

Comments

4 comments

  • Avatar
    Duc Ha
    Unfortunately this is the current limit of the "transpose" operator so I don't think it can be raised.
    0
    Comment actions Permalink
  • Avatar
    O A
    Do you have a workaround or another solution for me? I need to supply a report of data per date/geo somehow. I could settle on removing the least significant 50 countries, but currently it is random. The most important countries might have been removed, and we wouldn't know. This limitation have a great effect on our BI capabilities. It's like using statistics with one hand tied behind our backs. Theoretically I can download to Excel and use pivot tables, or create a lot of queries - one per day - and somehow connect then. But honestly, I got better things to do than sitting on statistics all day. I want to provide a reliable data to the decision board. Currently they don't trust the data coming from SL because of this (along with the no-http-support of the collectors, that one was harsh).
    0
    Comment actions Permalink
  • Avatar
    Duc Ha
    Can you join our SumoDojo slack channel? I can invite you but I'll need your email.
    0
    Comment actions Permalink
  • Avatar
    O A
    Gladly, it is: oria at adopt dot media
    0
    Comment actions Permalink

Please sign in to leave a comment.