sotagraphs.com - graphs for the API data

Discussion in 'Player Created Resources' started by that_shawn_guy, Jun 2, 2019.

Tags:
  1. Spungwa

    Spungwa Avatar

    Messages:
    609
    Likes Received:
    1,252
    Trophy Points:
    93
    Shaun
    (edit should of @that_shawn_guy )

    I was looking at a graph, very good by the way.

    I was looking specifically at
    https://sotagraphs.com/d/EgTXn0MWz/crafting?orgId=2

    Is this counting the amount of the item destroyed and created or is it the number of events.

    IE for the potion of restoration, imbued potions.
    The recipe makes 3 potions
    uses
    15 Garlic for example

    So if a single craft of this recipe would this add 1 to the crafted potions or 3
    and likewise
    would it add 1 to garlic or 15.

    It just the numbers seem low to me for the amount of some of these materials that i see being sold.


    Regards
    Spung
     
    Last edited: Jan 22, 2020
    Anpu likes this.
  2. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,074
    Likes Received:
    2,843
    Trophy Points:
    125
    Location:
    earth... mostly
    It's totaling up the quantity fields of the events.

    One thing to keep in mind, these events include character names. If someone is hiding their name from the API, those events will not show up here.
     
    Sean Silverfoot and Anpu like this.
  3. Spungwa

    Spungwa Avatar

    Messages:
    609
    Likes Received:
    1,252
    Trophy Points:
    93
    Oh right, it doesn't log all those characters it against anonymous character like some of the other stuff.

    That would do it then, so it a sample, useful for ratios, but not totals.
     
    that_shawn_guy and Anpu like this.
  4. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    When doing a search for Maple Wood, there is some very strange area showing up as "Novia_R1_Forest04_01" except, all forest scenes in the game only go from 1-3. Either this is a typo? Or is the API actually reporting that?

    Is that something you could check?

    I am almost positive it SHOULD be reporting area "HiddenVale_Forest01_Tier5" (Greymark Forest) which is strangely absent when searching for Maple Wood. And that has CRAPLOADS of Maple Wood.

    Thanks!
     
    Last edited: Jan 23, 2020
  5. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,074
    Likes Received:
    2,843
    Trophy Points:
    125
    Location:
    earth... mostly
    "Novia_R1_Forest04_01" is what's in the API.

    Code:
          {
            "_index": "logstash-2020.01.21",
            "_type": "doc",
            "_id": "D8tyxW8B9DlaFXTYXoKy",
            "_score": 1.0,
            "_source": {
              "EconomyGoldDelta": "3",
              "Archetype": "Ingredients/Materials_Raw/ItemRawMat_Wood_Maple",
              "SceneName": "Novia_R1_Forest04_01",
              "zpos": "-312.962",
              "LocationEvent": "ItemGained_Loot",
              "xpos": "345.619",
              "ypos": "-0.305",
              "ItemId": "5e2642224d97ac1570341281",
              "@timestamp": "2020-01-21T00:00:00.000Z",
              "Quantity": "1",
              "GoldValue": "3",
              "timestamp": "Jan 20 18:00:00"
            }
     
    StarLord, Anpu and Elgarion like this.
  6. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Thanks for checking that. I completely forgot to just check one area *facepalm*.
     
  7. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,074
    Likes Received:
    2,843
    Trophy Points:
    125
    Location:
    earth... mostly
    It would be very nice to have a conversion table for this kind of data in the api.
     
    Aeryk and Anpu like this.
  8. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Completely agree. I now plan on posting a monthly resource report. Hopefully this will get some attention from the team, as well as provide us discussion on these.
     
    that_shawn_guy likes this.
  9. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Can you possibly add an option where the actual exact number are shown, with NO abbreviation?

    Currently items are displayed like this:

    [​IMG]

    I need that K removed, and instead an actual total number, with no K abbreviation.

    Could you possibly add such a selectable display option? I don't wan't to mess with the default display, which is fine for most people, but add an option we could select that only shows exact total numbers with no abbreviations (some cookie or session selectable option)?

    If that's WAY too much work for you to do, no worries. Never mind. Just wanted to ask first. :)
     
  10. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,074
    Likes Received:
    2,843
    Trophy Points:
    125
    Location:
    earth... mostly
    Sure. It's a per-graph setting though. If you click on the title of the graph, you can share a link to it and I can update the settings for it. Through the same dropdown, you can also go the inspect area and see the data for the backend of the graph. IIRC, you can also download it in CSV or maybe other formats.
     
    Anpu likes this.
  11. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    [​IMG]

    Lich Essence dropping in last 30 days

    @that_shawn_guy this *seems* abnormally low, but actually could be what is currently dropping. I was just wondering first that you do have the lich essence set up on the site correctly? It's possible the API is reporting this incorrectly...
     
    shawnbutts likes this.
  12. shawnbutts

    shawnbutts Avatar

    Messages:
    1
    Likes Received:
    1
    Trophy Points:
    3
    Anpu likes this.
  13. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    Ok thanks for checking. This is probably correct since troll essence is now all the rage.....
     
  14. Anpu

    Anpu Bug Hunter

    Messages:
    5,241
    Likes Received:
    5,793
    Trophy Points:
    153
    Location:
    Pacific Northwest
    The Economy page data seems a bit wacky. In the last 30 days it shows 1.94K coal has been purchased by NPC's. But the crafting page Crafted Items Destroyed shows 167K Coal destroyed?
     
    that_shawn_guy likes this.
  15. that_shawn_guy

    that_shawn_guy Bug Hunter

    Messages:
    1,074
    Likes Received:
    2,843
    Trophy Points:
    125
    Location:
    earth... mostly
    Good find. I had them set to using different aggravation functions. Should be fixed now,
     
    Sean Silverfoot and Anpu like this.