Ann E.

Fixing Numeric Precision Issues in Mixpanel Reports

Hey everyone! I’ve got a question about numeric precision in Mixpanel. We’re sending very small fee values from our trading app (e.g. 0.00000841 BNB). In the event properties they show correctly, but in tables/reports Mixpanel rounds them down to 0, which breaks our analytics. Is there a way to disable rounding or increase decimal precision for numeric properties? Any workaround would be super helpful. Thanks!

3Comments

Commented on Mixpanel Alert List Parsing Issues: Need Help with...·Posted inCommunity Questions

Ann E.

Andrew S. In our project it looks like this (js):


mixpanel.track("Advanced Alert Added", {
  // other properties 
  "Alert Operands": ["price", "price"],
});

Since we also have Firebase as a provider, our events are wrapped in classes and then mapped to events for each of the providers. Event (first argument): Advanced Alert Added Object with parameters (second argument)

                   
{
    "distinct_id": "IQnW69ncTJYdxPzPuqgTzbtsMFy2",
    "time": 1724961798.712,
    "Screen Name": "Alert List",
    "Alert Operands": [
        "price",
        "rsi"
    ],
    "Alert Operation": "crossing",
    "Alert Timeframe": "m1",
    "Exchange ID": "BINANCE",
    "Symbol Title": "BTC/USDT",
    "Symbol Subtitle": "USD@-M",
    "Symbol Name": "BTC/USDT USD@-M",
    "Market Name": "BINANCE - BTC/USDT USD@-M"
}

Commented on Mixpanel Alert List Parsing Issues: Need Help with...·Posted inCommunity Questions

Ann E.

I assume the problem ie in this part: "Alert Operands": [ "price", "price" ],

Commented on Mixpanel Alert List Parsing Issues: Need Help with...·Posted inCommunity Questions

Ann E.

For example, this is how JSON looks like


{
  "event": "Advanced Alert Added",
  "properties": {
    "time": 1724932557.103,
    "distinct_id": "hbpJEaZMZCelfQuzgAw0YpGN2av1",
    "$app_build_number": "1.22.1",
    "$app_version_string": "4637",
    "$browser": "Chrome",
    "$browser_version": 128,
    "$city": "Bishkek",
    "$current_url": "https://env.tabtrader.com/tab-7904/alerts?list=%D0%A5%D0%BB%D0%BE%D1%80%D0%BE%D1%84%D0%BE%D1%80%D0%BC",
    "$device_id": "1916fee194e10ca-09305ed34f2a74-26001e51-1fa400-1916fee194f146b",
    "$initial_referrer": "https://env.tabtrader.com/dev/watchlist?list=Binance",
    "$initial_referring_domain": "env.tabtrader.com",
    "$insert_id": "07rxwhfa5e6zmjm7",
    "$lib_version": "2.45.0",
    "$mp_api_endpoint": "api-js.mixpanel.com",
    "$mp_api_timestamp_ms": 1724932561008,
    "$os": "Windows",
    "$region": "Gorod Bishkek",
    "$screen_height": 1080,
    "$screen_width": 1920,
    "$user_id": "hbpJEaZMZCelfQuzgAw0YpGN2av1",
    "Alert Operands": [
      "price",
      "price"
    ],
    "Alert Operation": "crossing",
    "Alert Timeframe": "h1",
    "Exchange ID": "BINANCE",
    "Market Name": "BINANCE - SOL/USDC USD@-M",
    "Screen Name": "Alert List",
    "Symbol Name": "SOL/USDC USD@-M",
    "Symbol Subtitle": "USD@-M",
    "Symbol Title": "SOL/USDC",
    "mp_country_code": "KG",
    "mp_lib": "web",
    "mp_processing_time_ms": 1724932561826
  }
}

Commented on Mixpanel Alert List Parsing Issues: Need Help with...·Posted inCommunity Questions

Ann E.

Andrew S. It is displayed as string. What could be the problem when sending the event if we’re doing everything exactly as stated in the documentation?

Posted in Community Questions·

Ann E.

Mixpanel Alert List Parsing Issues: Need Help with JSON Format

Hi, we’re trying to send a list of operands used in an alert, but Mixpanel is displaying them as strings in the filter instead of as selectable options. We’re sending a JSON list according to the documentation here. However, in the filter, they appear as strings, meaning Mixpanel isn’t parsing them into options like “trendline,” “rsi,” etc. Here’s the event list I’m referring to: Mixpanel Event List. Could you please help us figure out if we’re sending something incorrectly, or if there’s a setting we need to adjust so that Mixpanel can correctly parse the list we’re sending?

1 attachment

11Comments

Commented on Average Time for Users to Add Ticker After Profile...·Posted inCommunity Questions

Ann E.

Ali B. thanks you a lot!

Commented on Average Time for Users to Add Ticker After Profile...·Posted inCommunity Questions

Ann E.

yes, thanks^ but i want to know time to conversion of this events 3 TIMES. How much time it takes to do it N times for user

Posted in Community Questions·

Ann E.

Average Time for Users to Add Ticker After Profile Creation

Hello everyone, I have a question. I want to check how much time it takes on average for a user, after registration (event: Profile created), to add a ticker three times (event: Ticker Added).

4Comments

Commented on Linking Mixpanel Events for Analytics on User Reba...·Posted inCommunity Questions

Ann E.

Ansh A. yeah, thanks, that definitely will help)