Building and Sharing Your Analysis

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

  • 777 Topics
  • 2,092 Replies

777 Topics

J
Novice
Julia PhillipsNovice
posted in  Building and Sharing Your Analysis

Error message on dashboard page: something went wrong

HelloI keep receiving this message on reports I’ve created: I’ve tried using the most recent versions of Chrome and Edge. Can someone please help?Julia

12
R
1 month ago
Q
quintinparNew Member
asked in  Building and Sharing Your Analysis

Overlay one graph over another?

I want to visualize a particular error event in comparison to DAU. Is there a way to achieve this? 

1
Saish Redkar
Expert
1 month ago
Q
quintinparNew Member
asked in  Building and Sharing Your Analysis

Compare how many times an event has been fired but bucket it based on different properties?

I have an event, lets call it “FoodPurchased” that gets trigged on checkout. FoodPurchased has a property DishName. How do I compare and see the number of times they’ve been triggered in a period. y axis is the frequency and x the property names?

3
dangrainger
Super Helper
1 month ago
Jonne
Conversationalist
JonneConversationalist
asked in  Building and Sharing Your Analysis

Multiple optional events in a Conversion funnel

Hi, My colleague and I have been trying to recreate our entire upload funnel for sellers on our website. With this we would like to be able to see more specifically at which points in the flow our users usually drop-off.In doing so we encountered multiple events that are optional, and we also found the option to make events optional in the funnel. It also really helps that you can group multiple events inline, so that a multi-step process within the flow can become optional.The upload process can however not be completely recreated because we are only able to make one event optional. Why is that exactly? We would like to be able to recreate every step using our Events “in exact order”.How would you advice us to go about in our situation? How can we map out our entire funnel in the most exact way?Thank you in advance for your advice.Kind regards,Jonne Zomerdijk

0
Jonne
Conversationalist
1 month ago
H
Helpful Hero
Herb LauHelpful Hero
posted in  Building and Sharing Your Analysis

something like DISTINCT COUNT in Excel?

In an attempt to check on engagement on a page, I’m trying to find the most popular events on a given set of webpages.  I normally default to pulling unique users on any active event, but in this case switched to event totals, on a filter of the page URL containing a specific condition.I don’t really see a way to do that, and the default Amplitude Event Name seems to (I assume) only focus on Amplitude default events, rather than events we’ve created. Any thoughts on this?  Thanks!   

1
dangrainger
Super Helper
1 month ago
G
Grégoire RoquetteNew Member
asked in  Building and Sharing Your Analysis

Evolution of a 5 day Revenue LTV over time

Hey guys,  I’m trying to create a chart to visualise the evolution of the 5 day LTV generated by clients over time. I have created a cohort for customers who subscribed the same week. I would like to plot the 5 day LTV of the cohort week 1, then the 5 day LTV of the cohort week 2… On the x-axis would be the cohorts (from week 1 of subscription until week n), and on the y-axis their 5 day LTV.  Any ideas how I could do this ?  Thanks !  Greg

0
G
1 month ago
S
Skich Limited
asked in  Building and Sharing Your Analysis

How to track the average amount of actions per 30 days

How can I track average amount of actions for 30 days among users cohort (e.g. new June users)? Here I try to make a graph, but it turns out that users from June 21 count actions only for 9 days (till the end of June), not for 30 days. I need to track 30 days average among users that made their first action on June 1st as well as for users that made first action on June 30th.https://app.amplitude.com/analytics/demo/chart/new/ci2uwh38 

2
S
1 month ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

Total events but with unique event property value

Hi,I want to analyze how many songs have been played by (e.g.) length, but count each song only once.So imagine 10 times a song has been played, I want to know that 3 of them were 5mins long, and 2 of them 6 min, but not count every unique song only once. (so 5 songs were counted already)So far I can only count unique users or total events, both do not do the trick.The song played event has a songID property.Any help is appreciated.

1
K
Well-Versed
1 month ago
M
Novice
MichaNovice
asked in  Building and Sharing Your Analysis

Histogram Number of Sessions per User

Similar to the distribution of session length in the User Sessions graph, I would like to have a distribution of (number of) user sessions per user that shows the same kind of histogram.e.g1 Session    - 2.000 users2 Sessions   - 5.000 users3+ Sessions - 10.000 usersIs this possible in Amplitude?I did not find such an option in the User Sessions chart.What I tried is the  Segmentation Chart with a custom formula using HIST() AND PROPCOUNT() on the Session ID, but I could not get a working chart.Any help would be greatly appreciated.

1
Saish Redkar
Expert
1 month ago
R
RyanNew Member
asked in  Building and Sharing Your Analysis

Is there a way to have dashboard level filter only apply to one event in a funnel chart?

When I filter for a specific URL with a dashboard level filter it applies to both event 1 & 2 of funnel charts when I only want it applied for event 1. I know I can remove it ad hoc but there will be multiple users on the dashboard filtering for different URLs. Is there a way or a setting to have dashboard level filters be applied to only event 1 and NOT event 2?

0
R
1 month ago
S
Well-Versed
sysphWell-Versed
asked in  Building and Sharing Your Analysis

Amplitude time zone setting

hi there,How do I ensure our data in London time (GMT / GMT + 1 in summer)? Is UTC same is GMT in Amplitude?  It’s default by UTC in Amplitude.  Will be i able to switch to GMT?  Thanks 

4
S
Well-Versed
1 month ago
I
Iana KotrelevaNew Member
asked in  Building and Sharing Your Analysis

Incorrect OS value. It equals Mac OS 117 or Windows 118

Hello!Could you help use with the OS field issue? We are using Segment that sends data to the Amplitude. All of our users are using only Web. What we get is the OS field has in its value operational system of the web device, for example to Mac OS 117 or Windows 118. I would find it correct but according to the docs, OS field is supposed to be the name of the user's mobile operating system or browser. As I understand it should be the browser in our case because there is not traffic from the mobile. What can be the issue? How can we get the browser version? Ideally, we want to know the browser, its version, OS, and its version. Is there a way to achieve this? The data that Segments collects is correct. It sends User agent and User agent data when possible. Also, what is the reason for OS being two different things, like "ios 9.1" or "Chrome 46"? It’s confusing. And moreover, with this setup, we don’t have a full picture.Thanks!

0
I
1 month ago
C
Experienced
Cortney KetchumExperienced
asked in  Building and Sharing Your Analysis

Data Table Column Limits

Wanted to know how many ‘top level group by’ are allowed within a data table? It seems to be limited to 5. I’d like to build a pretty big report for contract management, but that doesn't seem possible. 

10
C
Experienced
1 month ago
R
Renan SilvaNew Member
asked in  Building and Sharing Your Analysis

User property on Funnel Analysis

Hi there! I'm looking into a funnel analysis with 4 major steps, A, B, C and D. But it would be very important to filter users by a user property X that is set on B step/event…In this case, if I create a funnel "Conversion from A to D" and filter users by property X, will Amplitude understand which users had received this property on step B and consider them from the beginning? Thanks! :D

2
R
2 months ago
S
Srinivas HarivanamNew Member
asked in  Building and Sharing Your Analysis

Editing Summary Metrics on Amplitude dashboards

I have created charts on the amplitude dashboard to view the metrics grouped by by platform type(lets say platform A or platform B). Currently, when I try to view the summary metrics on the charts, we have the option to view the summary metrics for either platform A or platform B. Is there a way to configure the summary to view the sum/average of the metrics for platform A and platform B together on the charts?

0
S
2 months ago
C
Novice
Cameron RossNovice
asked in  Building and Sharing Your Analysis

How to create query - does > pages per session lead to > sessions?

Hi all,I’m trying to formulate a question into an Amplitude query, but I’m not sure exactly how to. I have a view_page event (for any page view on our site) and a start_session event (for any session on our site). The simplest version of the question is: if someone performs more page views in a session, does that make them more likely to come back? Does a higher view_page divided by start_session mean more start_sessions in future?I am ideally looking for an indicator of causation, but I’ll settle for correlation at this point.I can create a segmentation chart that does a formula on totals(view_page)/totals(start_session) to see averages, no problem. I can even segment this view by people who have done 1 session last month v.s. 2 sessions v.s. 3-5 sessions etc etc. But I kind of want the inverse of this - to count the sessions, but segment by the totals(view_page)/totals(start_session) value.The retention chart seems like it would be the right place, but gives me no way to do the total

1
C
Novice
2 months ago
N
Nicolie NgNew Member
asked in  Building and Sharing Your Analysis

Ways to find first landing page

I’m brand new to Amplitude and would like some clarification on the difference of the following features. The question I’m trying to solve is: what are people’s first landing page? I’ve tried the following three ways:1. under Data table chart, group by Event Name (covers all the pages I care about) under “overall” then make use of first-touch attribution after I selected “Any Active event” as the event, note that time period is set to last 30 days2. like above, under Data table chart, group by Event Name (covers all the pages I care about) under “overall” and used Session Entries to get break down of counts of each event name3. under Event segmentation chart, pick a page then set Historical Count = 1st ( and I will be doing the same thing for other pages to compare them against each other )Any help/explanation are appreciated, thank you!  

0
N
2 months ago
S
SethuramanNew Member
asked in  Building and Sharing Your Analysis

I want the number of unique events where event property is also unique. How do i find that?

My use case is this. I need to measure unique logins to my system. User A has user id 100 and logins in via mobile in the morning and logins in via laptop in the evening. So there are 2 unique events now. However for both these unique events the event property (user id) is 100 only. So now I want to know events for unique event property. For example: - If user A with user id 100 logins in mobile and laptop and User B with user id 102 logins in with mobile and laptop - there are 4 unique login events.However from my POV there are only 2 unique users only. Please explain to me, how to build a chart for this. Thank you

3
Z
2 months ago
V
Valentin LecomteNew Member
asked in  Building and Sharing Your Analysis

Writing an absolute value in a chart

Hi, I’m trying to create bar chart in the segmentation tool. I’m using the formulas. I would like one of the bars in my chart to have a fixed value (“1.72”). I tried to write it in different ways in the formula form, but I always get an error from Amplitude. Is there a workaround for this? Thanks 

2
V
2 months ago
matt
Novice
mattNovice
asked in  Building and Sharing Your Analysis

Rolling Median

Hi all, I know it’s possible to calculate rolling averages and rolling windows using formulas, but has anyone come up with a formula for calculating a rolling median? Something like FREQPERCENTILE(A, .5), but applied over various durations. — Matt

0
matt
Novice
2 months ago
C
Conversationalist
ccanamasConversationalist
asked in  Building and Sharing Your Analysis

How to calculate MAU per GROUP?

Hi, my organization has the Accounts Add-on feature, which we use to track “license” level behavior in our B2B product. So, we track individual user behavior, but also associate users with a higher-level license, which we define as a “group type”. For simplicity, we can assume most users are associated with 1 and only 1 license group. We want to track not only DAU/MAU, but also DAU and MAU per license. So, something like the UNIQUES(A) formula that calculates MAU in an event segmentation chart, modified to something like UNIQUES(users) / COUNT DISTINCT(license groups). Any ideas on how to accomplish this? Thanks!

3
JennRu
Community Manager
2 months ago
Z
Zayyan ChowdhuryNew Member
asked in  Building and Sharing Your Analysis

Users who did not pageview within last 90 days

Hello, I’m trying to understand how I can build a cohort of users who had a pageview before the last 90 days and have not since.However, the way the logic is built now seems very confusing.Is this the correct way to look at it? The way the logic stacks makes it very confusing. The way I read this is, user did page view since jan 1, then if at any point since that date they did not do pageview within 90 days, they are included.That does not get to the essence of the question, which are users who have not done pageview in the last 90 days.

1
JennRu
Community Manager
2 months ago
Jonathan Callahan
Jonathan CallahanNew Member
posted in  Building and Sharing Your Analysis

The "Report Slowness" form not working is really almost a piece of art

Reloading a blank screen for five minutes and the place to report this issue is borked. Great job team

0
Jonathan Callahan
2 months ago
K
k.lizutNew Member
asked in  Building and Sharing Your Analysis

Inserting dictionary parameter into Event segmentation API query

Hi, I’ve been trying to pass parameter which is a dictionary into Event segmentation API query but I get empty response (status code 200)My code looks quite like this:Could you help me with that? Thanks in advanceRegards

0
K
2 months ago
M
Mahesh RajaNew Member
asked in  Building and Sharing Your Analysis

How add the values of different events and show it on chart

Hi, I am trying to add all the data with similar values in charts, however I am not sure of the process.For eg: If there are following unique users by OSAndroid - 100Ios - 200Mac OS - 100Samsung - 200 When the chart is displayed, I want to add Android + Samsung & ios + Mac OS, so that following output can be viewed in charts: A (Android + Samsung) - 300B (ios + Mac OS) - 300 Thanks,Mahesh

2
M
2 months ago

Terms & ConditionsCookie settings