topic Re: group results in a form in Dashboards & Visualizations

group results in a form

lancealotx — Wed, 08 Aug 2012 18:50:11 GMT

Same as some others trying to grasp my understanding on how the language works. Well I have a bunch of data based on specific points. I want the user to enter a number, have it return the following;

the member of the user that hit it (grouped by this) along with the apikey, nothing else right now.

I have my form that prompts for an ID, when hit, I get ALL the data, but nothing grouped, and I did try a bunch of ways; here is the form;

<form>
  <label>Unique Users by Spot</label>
  <searchTemplate>
    member !=-1 AND (ApiKey="123" OR ApiKey="456" OR ApiKey="789" OR ApiKey="abc")  
    spotId=$Spot Id$ 
    | fields memberId ApiKey
  </searchTemplate>
  <fieldset>
      <input type="text" token="Spot Id" />
      <input type="time" />
  </fieldset>
  <row>
       <table>
          <option name="showpager">false</option>
          <option name="count">50</option>
     </table>
  </row>
</form>

Sample results is;

1 8/6/12 9:55:00.826 PM 229424 abc
2 8/5/12 7:30:51.661 PM 273755 123
3 8/5/12 3:44:17.216 PM 229424 abc

the _raw is also displayed, but row's 1 and 3 are the same user (229424) so I would like to group on that. Tnx

Re: group results in a form

reed_kelly — Wed, 08 Aug 2012 19:24:09 GMT

After "fields memberId ApiKey" just add:

|dedup memberId, ApiKey |table memberId, ApiKey

Re: group results in a form

lancealotx — Wed, 08 Aug 2012 20:20:01 GMT

Thanks, when I tried that, I ended with no results found. I did play a bit get some results by ending with this;

|fields memberId ApiKey |dedup memberId|table memberId, ApiKey

That gives me 5 rows of data (which seems correct) with the 5 members that hit that spot. The api key however is blank. The api key is how their getting to us (website, iphone, android), so a user could have multiple, but all of that column is blank. I don't care so much (right now) about how, that will be later, right now I would like to know in the timeframe;

user: 12345 10 times
user: 56778 5 times

Re: group results in a form

reed_kelly — Wed, 08 Aug 2012 20:27:51 GMT

In that case, you can replace the fields, dedup and table commands with:
|stats count by memberId, ApiKey

The blanks for ApiKey are strange, because you are testing for that above. You can always leave it off the stats command.