Building and Sharing Your Analysis

Learn, ask questions, and help others build Amplitude charts and gain valuable insights!

  • 848 Topics
  • 2,258 Replies

848 Topics

S
Helpful Hero
sergiiHelpful Hero
asked in  Building and Sharing Your Analysis

How to make a calculation between events and display the result on a "Bar chart" for each month within several months?

Good afternoon, dear Support service!I have a chart that displays 2 events A and B for the last 17 months. I need to do pre-calculations before rendering the chart. It is necessary to subtract event B from event A and display the result on the chart as event A and display event B next to it. We should get something like this https://i.imgur.com/uOXb1ue.png or something close to it. But when I do any calculations through the Formula input, this option for rendering the chart is not available to me. How can I achieve the desired result?

1
Saish Redkar
Expert
1 year ago
guenena
guenenaNew Member
asked in  Building and Sharing Your Analysis

Bucketing users by properties for funnel analysis / How do User Filters work

Hi everyone, I’m new here and this might be a well known answer – I tried searching but wasn’t able to find one. My high level goal is to set some user Amplitude properties that I can later on use to bucket users into categories and use that for funnel analysis. The problem is at user signup I don’t have the values for those properties yet (for example the user hasn’t shared their location yet) I wanted to understand first what those two user filtering properties mean: Is the following correct for the following image: Any Events that are performed by any user who at the current time (not the time of the event) their User Property Country = “United States” (i.e. a user who had an empty Country at the time of the event but their current User Property Country = “United States” will be included) Filter applied to event #1  Is the following correct for the following image: Any Events that are performed by any user who at the current time (not the time of the event) their User Property Count

4
guenena
1 year ago
K
Conversationalist
kavithajayaramConversationalist
asked in  Building and Sharing Your Analysis

Using an array in one specific event property corresponding to one specific event

Hi Happy to be part of this community. This is my first post here. i am looking to send an event property along with a crash event in below array form. Here I am trying to get the history of incidents x, y, z (from an event property called history) that happened before the actual event crash. Objective is to later classify how many of these x contributed to crash, how many of y contributed to crash etc . Pls note all of x, y, z are not implemented as separate events in amplitude.Sample format:Event name: crashEvent property name: historyEvent property values for history: {x,y,z} in that orderIs above structure ok to move ahead with?If yes, I also want to make a pathfinder or funnel chart or some other chart to understand how many of x usages led to crash and how many of y usages led to crash later. Is there some way in which I can use pathfinder chart and filter out counts by event properties to achieve the same 

2
Jeremie Gluckman
Team Member
1 year ago
S
Helpful Hero
sergiiHelpful Hero
asked in  Building and Sharing Your Analysis

How to add the calculation of any two events to the ROLLWIN() function?

Hello dear Support service!I have previously submitted a question to the ticket https://community.amplitude.com/building-and-sharing-your-analysis-58/how-can-several-events-with-certain-time-intervals-be-displayed- in-one-chart-1030?postid=3547#post3547 for which you quickly found a solution, for which I am very grateful!Since that ticket is already marked as RESOLVED, I decided to create a new ticket.I need to add another chart where I will use events A and B in it (these can be any events)First I need to do some simple math between events:Event A multiplied by 100 and divided by event B - A*100/B.Next, I need to substitute the result of these calculations in the ROLLWIN() form in order to display the result of the formula on the chart. But I can't do that because the specific syntax of the ROLLWIN() formula doesn't allow me, I can only use:ROLLWIN(UNIQUES, A, 7)ROLLWIN(TOTALS, A, 7)So the question is, how do I substitute the result of my calculations (A*100/B) into the ROLLWIN() form

3
Saish Redkar
Expert
1 year ago
S
Helpful Hero
sergiiHelpful Hero
asked in  Building and Sharing Your Analysis

How can several events with certain time intervals be displayed in one chart?

Good afternoon dear community. I need to create one chart and I have one event which comes from Segment service. I need to display in the chart the sum of incoming events for the previous 30 days. And also for every day during the past 30 days. For example, today is May 11, I need to display the number of events from May 11 to April 11 - this will be the 1st bar in the chart, then I need to display from May 10 to April 10 - this will be the 2nd bar in the chart and so on until the date interval from April 11 to March 11. That is, there will be 30 bars in the chart with intervals in the previous 30 days. The key is that it would not be necessary to manually select date intervals for 30 days, but that they would be set up automatically (the last 30 days were simply taken). I found that under each event you can add a where "Server upload time" condition. That is, there is a way to add 30 identical events and manually add the where "Server upload time" condition to each of them, but the pr

10
Saish Redkar
Expert
1 year ago
A
allanthomasofNew Member
asked in  Building and Sharing Your Analysis

Error while generate appbundle with Flutter

Hello,i’ve integrate my app with Amplitude and he works fine, build app and send events, all its OK.But, my problem is when i try generate the appbundle (.aab) of my application with command flutter build appbundle.The problem was started when i installed the pub flutter_amplitude, i try install all versions, but the problem persists.If i remove the amplitude, i can generate the appbundle without problems.The error showed on the terminal is:Gradle build failed to produce an .aab file. It's likely that this file was generated under C:\dev\myapp\build, but the tool couldn't find it.I’m using:Flutter: 2.5.3Dart version 2.14.4Anyone can help me, please? Thanks!!

1
A
1 year ago
rahulsekhar
rahulsekharNew Member
asked in  Building and Sharing Your Analysis

Visualizing grouped data

We’re tracking an event when a user attends one of our sessions - grouping these events by the session ID, we’re able to see the attendance for each session (see below):What we’d really like to see is the data organized a little differently - a histogram of how many sessions were attended by 0-20 members, how many were attended by 20-40, how many by 40+. Is there any way for us to do this?

2
Saish Redkar
Expert
1 year ago
N
Narong T.New Member
asked in  Building and Sharing Your Analysis

Tooltip displays an Incomplete information

Why is it that when I enter text with Thai amplitude, the information is show incomplete?Round #1: enter Enter only English informationResult: show complete informationAmplitude Result:Original information:Round #2: enter Enter only Thai information Result: show incomplete information Amplitude Result:Original information:Note: If entering English and Thai information, it still doesn't show complete information.

2
Thao Nguyen
Team Member
1 year ago
C
csjhNew Member
asked in  Building and Sharing Your Analysis

Stickiness Over Time

Hi! I was exploring the stickiness over time charts and looking through some of the blogs. I realised that Day 4 and Day 1 is not showing up on the chart. Does anyone know why is that the case? 

2
Saish Redkar
Expert
1 year ago
timothy-permutable
Super Helper
timothy-permutableSuper Helper
posted in  Building and Sharing Your Analysis

Calculating and Benchmarking Day N Retention (D1R, D7R, D30R)

There are loads of great resources available about retention in Amplitude, but I thought I’d write my own take for beginners.https://timothydaniell.medium.com/how-to-calculate-benchmark-day-1-day-7-and-day-30-retention-in-amplitude-analytics-d500a77eae04

1
Saish Redkar
Expert
1 year ago
J
Novice
jackrobins2022Novice
asked in  Building and Sharing Your Analysis

Property names questions

When creating an eventing taxonomy, I came across an Amplitude template for BtoB companies. I noticed that property names have different type of naming conventions across different events. I guess my question is, what role does a property name play in the overall scope of the taxonomy? Why not just have a property name be “type” instead of “cta type”, for example?   

2
J
Novice
1 year ago
D
dpommoNew Member
asked in  Building and Sharing Your Analysis

Measuring month on month retention

Hi,I’m trying to analyse month on month retention for different users groups (those who were existing users in the previous month and those who were new users in the previous month) but I can’t seem to create a chart which gives me this analysis and also can’t find anything in Amplitude documentation which supports this.Has anyone had any success in performing this kind of analysis with Amplitude charts? I thought I had found a way to do it by creating two user segments in a Segmentation chart, one segment is users who had performed the active event in each month and the second segment is users who had performed the event in the current month, offset by one month. Sadly this doesn’t give me the right numbers.Many thanks!

2
belinda.chiu
Team Member
1 year ago
D
Novice
dadasaheb.patilNovice
asked in  Building and Sharing Your Analysis

How to get full chart result without pruning in REST API?

How to get full chart result without pruning in REST API?Currently I am using REST API like -curl -u API_Key:Secret_Key 'https://amplitude.com/api/3/chart/CHART_ID/query'by passing CHART_ID.When I am looking at chart table data it is showing full data and even when I am exporting csv data it is returning file with full data. But when I am doing same thing with REST API, it is pruning data and not returning full data.Can you please help me to get full data without pruning using REST API?

8
Denis Holmes
Team Member
1 year ago
W
wubekNew Member
asked in  Building and Sharing Your Analysis

URL grouping

Hello, i have a question about charts. I have data with search criteria, for example:type=home room_number=3 type=officeroom_number=2And i want to group this to count how many rows is with specific dimension, in this example type will be 2.

1
SheenaGreen
Super Helper
1 year ago
J
jsonNew Member
asked in  Building and Sharing Your Analysis

[Dashboard API] Is there a possibility of data being pruned when using Results from an Existing Chart

Hi there,I’m curious if there is a chance of data being pruned or failing to response due to massive chart data when using Dashboard API’s Results from an Existing Chart endpoint.I’m implementing a feature something similar to:a feature where users can view their profile’s page view counts. users can view who viewed their profile within the last few days, etc.So the chart I’ve created is basically page view events grouped by profile ID which will scale as more profile (users) are created.Thanks,

3
belinda.chiu
Team Member
1 year ago
M
MohamedNew Member
asked in  Building and Sharing Your Analysis

make an automation when user don't connect after 3 days

Hi, i'm New and i figure out how to Send an email To user when he doesn't connect After a 3 days.Thanks 

1
Saish Redkar
Expert
1 year ago
A
AbrahamsNew Member
asked in  Building and Sharing Your Analysis

What is the best alternative for measuring bouncerate on Amplitude?

Hey everybody im new here!I use Amplitude to measure how my A/B-test experiments are doing and one of the goals that I have for one of these A/B-tests is decreasing the bouncerate. I use now any active event as goal, but I’m not 100% sure if this is the right event to use. Since i’m not sure if an exit is also considered as an (active?) event. Anybody can help me with this?

2
A
1 year ago
E
EduardNew Member
asked in  Building and Sharing Your Analysis

Retention report - number of users on the graph and in the view menu do not match

Hi!While analyzing the retention report, I came across different data in the same report:1. Retention report says that there are 1,58% of users who came back on 26 day.The numbers of users at cohort is 1005, so there should be 1005*1,58%=16 users who returned at day 262. If i click at “view users” at day 26, i can see that there is only 3 users which is not the same as 16 at the previous bulletIf i download a CSV of that users and calculate retention, the number of returned users at d26 is 4 which is 0,32% from number of users at cohort (1232). Also number of users at cohort is different from the number on chart (1005 and 1232) Which data is correct? If I’m analyzing that report in incorrect way, tell me which one is correct. Thank you!

1
Yuanyuan Zhang
Team Member
1 year ago
C
chuckNew Member
asked in  Building and Sharing Your Analysis

Full list of country anywhere?

Hi, I have a rather simple question.Is there a full list of country names used on Amplitude somewhere?I want to map country names to ISO3166 country codes but some country names on Amplitude are different to the ones in ISO-3166. For instance, ‘Myanmar’ is the name in ISO-3166, but Amplitude uses ‘Myanmar (Burma)’. So it would be really helpful if there’s a full list of Amplitude specific country names. Do we have such?

4
Denis Holmes
Team Member
1 year ago
P
Well-Versed
pawanWell-Versed
asked in  Building and Sharing Your Analysis

amplitude is not working when adblocker is enabled

i am getting this error in console ..GET https://cdn.amplitude.com/libs/amplitude-8.17.0-min.gz.js net::ERR_BLOCKED_BY_CLIENT also i am able to send events to dashboard since the. ad-blocker extension is enabled, how do i make amplitude work when ad-blocker is enabled ? 

4
Jeremie Gluckman
Team Member
1 year ago
A
arainey1New Member
posted in  Building and Sharing Your Analysis

Figuring out your Aha! moment - how do you best do this?

Hi all,Really interested to know how important the concept of an Aha! moment is for companies using Amplitude? And also, how have you gone about figuring it out?Thanks!

1
Jeremie Gluckman
Team Member
1 year ago
L
Helpful Hero
liukaichiHelpful Hero
asked in  Building and Sharing Your Analysis

Querying OS Version

I would like to separate my users Android 5 and lower vs Android 6 and higher. Is there an easy way to do this in Amplitude?I tried to put “OS < Android 6” but when I broke it down in my User Composition it came up with all sorts of OS’s, including Android 10 and 11, so I know that doesn’t work. Is there something similar to Session Start where you can do a < or > comparison? 

1
Saish Redkar
Expert
1 year ago
MichaelK
Novice
MichaelKNovice
asked in  Building and Sharing Your Analysis

Question on "This order - any order" in the funnel analysis

Hey everyone, I’d appreciate your help! Trying to wrap my head around the difference between any order and this order in the funnel analysis in case of just two events.Based on the definition I expect the CR to be the same for the one-step funnel as there are no combinations other than Event A → Event B, but the result is different 

3
Thao Nguyen
Team Member
1 year ago
X
Well-Versed
xiaomeng.zhangWell-Versed
asked in  Building and Sharing Your Analysis

Get the specific value of all attributes of an event

Hi, Guys. We have a event. Get the specific value of all attributes of an event. This event has many properties including search term, color, model, etc.I want to know the specific value of each attribute under this event for each user. For example, 99% of users have a black color and a brandId of 1 

1
Denis Holmes
Team Member
1 year ago
H
hmbaaNew Member
posted in  Building and Sharing Your Analysis

amplitude applicationWillTerminate not working

Hello, I want to receive an event when the user forcefully shuts down the app. But, The code I wrote doesn't work.Isn't there a good way? code :     func applicationWillTerminate(_ application: UIApplication) {        print("applicationWillTerminate")        AmplitudeHelper.shared.sendEvent(eventString: "app_exit")}

2
Jeremie Gluckman
Team Member
1 year ago

Terms & ConditionsCookie settings