TelemetryDeck / Issues

When something is wrong in TelemetryDeck-Land, or if you have a cool idea how to make things better, this is the place to create an Issue.
https://telemetrydeck.com
36 stars 0 forks source link

Raw not displayed as single number #362

Closed mpdifran closed 6 months ago

mpdifran commented 6 months ago

I have a few queries that do calculations on events to land on a single number. It would be great to have a chart type that can display this in large text with a label. Currently it's very tiny text and hard to read.

Screenshot 2024-02-29 at 7 07 25 PM
winsmith commented 6 months ago

This should already be possible. Can you try the following please:

If that doesn't work, can you share the insight ID please?

mpdifran commented 6 months ago

I do have granularity set to all, and I'm using the table display mode. What I see is in the screenshot in the original post. Here's my query (not sure where to find the Insight ID).

{
  "aggregations": [
    {
      "aggregator": {
        "fieldName": "count",
        "name": "_purchase_successful_count",
        "type": "doubleSum"
      },
      "filter": {
        "dimension": "type",
        "type": "selector",
        "value": "Purchased Product"
      },
      "type": "filtered"
    },
    {
      "aggregator": {
        "fieldName": "count",
        "name": "_views_count",
        "type": "doubleSum"
      },
      "filter": {
        "dimension": "type",
        "type": "selector",
        "value": "View Picasso Pro Paywall"
      },
      "type": "filtered"
    }
  ],
  "appID": "XXXX-XXX-XXX-XXXX",
  "filter": {
    "fields": [
      {
        "dimension": "type",
        "type": "selector",
        "value": "View Picasso Pro Paywall"
      },
      {
        "dimension": "type",
        "type": "selector",
        "value": "Purchased Product"
      }
    ],
    "type": "or"
  },
  "granularity": "all",
  "postAggregations": [
    {
      "fields": [
        {
          "fieldName": "_purchase_successful_count",
          "type": "fieldAccess"
        },
        {
          "fieldName": "_views_count",
          "type": "fieldAccess"
        }
      ],
      "fn": "/",
      "name": "Conversion Rate",
      "type": "arithmetic"
    }
  ],
  "queryType": "groupBy"
}
winsmith commented 6 months ago

Thanks a lot, this'll help me find the cause way quicker!

mpdifran commented 5 months ago

Looks great now! Thanks for the quick turnaround!