Skip to main content

Building and Sharing Your Analysis

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

  • 942 Topics
  • 2,413 Replies
942 Topics
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis
Calculating on Data Table

Hi! I use formulas on graphs and they work like a charm! Now I want to calculate the following on the table element: You can see that my Store #1 is selling cars in different values. I want to sum all of the profit from Store #1 so I can group by different stores and see the profit per store. How'd I do it? 

741
Jacenda Davis
Team Member
5 months ago
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis
Using Formula On Data Table

Hi! I use formulas on graphs and they work like a charm! Now I want to calculate the following on the table element: You can see that my Store #1 is selling cars in different values. I want to sum all of the profit from Store #1 so I can group by different stores and see the profit per store. How'd I do it? 

780
M
Conversationalist
5 months ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis
Ranges for PROPSUM values

RANGES for Frequency The Ranges feature works great. ⭐️ Here’s an example. Segmentation: Song Plays measured as Frequency with custom bucket size of 5.  PROPSUM The Propsum feature also works great! ⭐️ Here’s an example. Segmentation: PROPSUM of points by user   PROPSUM Ranges Is there a way to count my users by the sum of their points in ranges ❓Example: Sum of Points - Point Range measured as Frequency with custom bucket size of 10,000 pts0-10,000 pts:            12,000 users  10,001-20,000 pts:   20,000 users  20,001-30,000 pts:   15,000 users   Thanks,  Anthony

1544
B
Community Manager
5 months ago
S
SanginNew Member
asked in  Building and Sharing Your Analysis
Segmentation chart : I would like to know the conditions for New, Resurrected, and Dormant in the lifecycle chart.

Hello everyone!  I am trying to use the Segmentation chart to view the metrics we use internally as a time series. For this, I need the data for New, Resurrected, and Dormant users from the lifecycle chart. Could you please assist me with how to define the conditions for these three types of users in the Segmentation chart? Thank you!

1191
Yuanyuan Zhang
Team Member
5 months ago
G
godsenalNew Member
asked in  Building and Sharing Your Analysis
How to Calculate Average Events per Post per User in Amplitude?

I’m trying to calculate the average number of times a specific event (let’s call it Event A) occurs per post for each user in Amplitude. Each occurrence of Event A has an associated article_id property that identifies the post. When I use Event Segmentation and group by article_id for Event A, I can see the average number of Event A per post, but not the average across all posts for each user. Any detailed steps or guidance on how to achieve this would be greatly appreciated!  

790
G
6 months ago
D
Dominique Burgunder-JohnsonNew Member
asked in  Building and Sharing Your Analysis
Can I collapse all of the rows in the table of a segmentation chart?

I am viewing a table in a Retention Analysis chart that has hundreds of rows, including “child” rows nestled below “parent” rows. Is there a way that I can collapse all of the “child” rows that are nestled below each “parent” row at once? Right now I seem to only be able to collapse them by clicking the down arrow to the left of each parent row, but doing that one by one is tedious and taking a lot of time for a table with hundreds of rows.

702
L
6 months ago
Phoenix
PhoenixNew Member
asked in  Building and Sharing Your Analysis
How do I add default event properties to a custom event?

Hello, everyone.I’m start to study Amplitude for the integration with my project.I have trying to add default event properties such as PageDomain, PageTitle, PagePath, etc. to my custom event.I have using default events such as PageViewed, Start Session, etc. in my project, but from my requirements I need to define custom event.I’d like to use default properties such as PageDomain, PageTitle, PagePath, etc. in my custom event.What’s suggestion to add these properties to my custom event ?I hope to anyone help me for this.Thank you.

6493
J
6 months ago
A
Adolfo RBINew Member
asked in  Building and Sharing Your Analysis
[DASHBOARD API] Funnel analysis - weekly results

how can I get consolidated results by week or month instead of overtime by day?Im using dashboard apis to create a funnel analysis

964
liuaud
Peer Moderator
6 months ago
Oliver
OliverNew Member
asked in  Building and Sharing Your Analysis
Is there a way to filter properties by character length?

I have an event that collects freeform string inputs from users. A lot of users will input really short responses (eg. less than 3 characters). I want to exclude all of those short length results in my group by analysis. Is there any way to to do this?

2331
Y
Team Member
6 months ago
I
India Partner NetworkNew Member
asked in  Building and Sharing Your Analysis
Tracking entry points from multiple resources

We have a page that lists resources and one can come to the page through multiple entry points which are:Through an email notification Any other page on the platform From their Home page: Dashboard that they see when they login Search Results Page: Once they perform the search and any matching resource is listed, they can click on the resource and asked to login, if they are not. Once they perform the search and any matching resource is listed, they can click on the resource and directly view the resource. From social mediaHow do I then track the multiple entry points and understand how did the user reach the resource page to understand the user behaviour? Can I track it using UTM for social media and referrer for some other page on the platform, however this will not help me filter the page viewed event successfully. Please advise. 

932
I
6 months ago
I
India Partner NetworkNew Member
asked in  Building and Sharing Your Analysis
Tracking entry points

We have a page that lists resources and one can come to the page through multiple entry points which are:Through an email notification Any other page on the platform From their Home page: Dashboard that they see when they login Search Results Page: Once they perform the search and any matching resource is listed, they can click on the resource and asked to login, if they are not. Once they perform the search and any matching resource is listed, they can click on the resource and directly view the resource. From social mediaHow do I then track the multiple entry points and understand how did the user reach the resource page to understand the user behaviour? Can I track it using UTM for social media and referrer for some other page on the platform, however this will not help me filter the page viewed event successfully. Please advise. 

871
Saish Redkar
Expert
6 months ago
J
joel.spiroNew Member
asked in  Building and Sharing Your Analysis
How can you show Average daily values of a chart in a dashboard?

​Lets say I have 3 segments showing the uniques of a given event, and I want to show on a dashboard the daily average uniques of each segment during the given time period (in this case 30d).In the line chart I can chose Average Values to get those metrics:However if I show this chart in the dashboard I can not get the average metrics.In the KPI options its not available:IF I change to the table view I can get the current day, and the previous day but not the Average.I could try change the chart to a Bar chart in order to force only have one value for the period, BUT that would no longer be the average during the period but rather the deduped uniques during the total period. I can not think of a formulario or rolling avg o window to get Daily average uniques for the given time period as a single metric to then show on a dashboard.For now the option is to have the Average value as the metric on the Line Chart, have the line chart on the dashboard, and the user then needs to enter into th

8303
U
6 months ago
Oliver
OliverNew Member
asked in  Building and Sharing Your Analysis
How do I format metrics to be whole numbers (remove decimals/round up)?

I have a metric that has decimals and want to round it to a whole number. Couldn’t find any formula or setting to do so. Any tips would be appreciated

2101
eddie.gaona
Team Member
6 months ago
Maria Soboleva
Maria SobolevaNew Member
asked in  Building and Sharing Your Analysis
Old User Property is pulled to our projects with Ampli Wrapper

Hello,I am experiencing an issue with the Ampli Wrapper in our Swift and Kotlin projects. We set up Amplitude Data and installed the Ampli Wrapper successfully.We had to rename one of the User Properties from createdAt to created_at to avoid a conflict with our projects’ properties. However, when we pull the updated data on the client sides, the property still appears as createdAt despite being correctly named in the Amplitude workspace.Screenshots are attached for reference. Could you please assist us in resolving this issue?Thank you!

1421
eddie.gaona
Team Member
6 months ago
D
Digital WorkplaceNew Member
asked in  Building and Sharing Your Analysis
Can I exclude weekends from my charts? Any updates

Are there any recent updates () - will a function or other method be implemented to exclude weekends directly from the charts? It would be incorrect to exclude weekends using a filter applied to events, as values for that day on the chart are simply zeroed out, further lowering the average indicator.Therefore, excluding the necessary days directly from the chart would be the optimal solution.

1131
Saish Redkar
Expert
6 months ago
M
Novice
Maciej ZiolkowskiNovice
asked in  Building and Sharing Your Analysis
Share resources - analytics best practices

Hi all,would anyone be so kind to point me to free resources (e-books, articles, video tutorials) on web analytics best practices?I’ve already found some related topics in this forum and got to know about playbooks and guides released by Amplitude. But I am also interested in any documents that other web companies have released. I’d be very grateful for useful links 🙂.Cheers,Maciej

931
B
Community Manager
6 months ago
P
Conversationalist
peckerbidsConversationalist
asked in  Building and Sharing Your Analysis
Make a funnel showing percentage of users who convert within and beyond 30 days

I currently want to make a funnel chart between event A and event B. I want to see the percentage of users who complete the funnel within 30 days of performing event A, as well as percentage of users who complete the funnel, but beyond 30 days of performing event A. Is this something possible to do? Thank you!

1423
liuaud
Peer Moderator
6 months ago
N
nadjareNew Member
asked in  Building and Sharing Your Analysis
Can I exclude weekends from my charts?

Hello everyone, I work for a B2B company and we want to track the monthly development of events by using timelines (see screenshot). Is it possible to exclude the weekends?Thanks for you help. 

175213
D
6 months ago
P
Paul KimNew Member
asked in  Building and Sharing Your Analysis
about retention chart

  I do not understand the sentence "Dividing 55,752 by 137,586 gives us a Day 3 retention of 63.8%," presented as the formula for overall retention in the document <How the Retention Analysis chart calculates retention> provided by Amplitude. Dividing 55,752 by 137,586 results in 40.5%, but it is stated as 63.8%. It seems that the denominator for the retention calculation varies for each day. If so, what is the reason for the varying denominator values in the overall retention for N-day retention?

970
P
7 months ago
S
Novice
swym teamNovice
asked in  Building and Sharing Your Analysis
Amplitude to Hubspot Sync

Hi, I am looking to integrate to hubspot using cohorts sync but I keep getting a permission error while doing so - saying that i do not have the right scopes. We have one sync created in a dev account but need help to get it to our actual production account

1415
T
Team Member
7 months ago
D
Derek WangNew Member
asked in  Building and Sharing Your Analysis
How to view users relevant to the funnel conversion in group level reporting?

In individual user reporting, you are able to see the events that the user has taken through a stream when inspecting. In group level reporting, I would like to know the users that performed Event 1 and Event 2 in a Funnel analysis. However, when inspecting the funnel, I am only able to view the group that was relevant which is not very helpful since I selected that group for the funnel. How can I see something similar for group level reporting?

1391
Saish Redkar
Expert
7 months ago
Y
Yangfenyue WangNew Member
asked in  Building and Sharing Your Analysis
How to share a Public dashboard with real tine data updates

How can I share a public dashboard with real-time data updates? In other words, I want users to be able to refresh the data and set their own time period without me needing to configure it on my end.

1691
Saish Redkar
Expert
7 months ago
S
Helpful Hero
Shubham PatelHelpful Hero
asked in  Building and Sharing Your Analysis
How do I compare the unique and total event counts for the same metric in a single chart

I have to showcase the total unique users for a click event compared to the total event count for the same click event - as a line chart comparison for the same event.When I take the two metrics together in the same chart, I am unable to add different measured as individually on the two items. Although I can show one as a percentage of other - my ask is that I have to show both volumes as well as unique users interacting with the feature.Is there a way to do so in the same chart.

2222
S
Helpful Hero
7 months ago
R
Helpful Hero
roginatorHelpful Hero
asked in  Building and Sharing Your Analysis
How can you sum up group property values?

We’re a SaaS company and we have a Group Property (Account) for number of todos added by all the users within the Group (Account), eg:Account A Todos: 100 Account B Todos: 120 Account C Todos: 90How can I create a chart displaying the total number of todos for all accounts, eg 210? IE a sum of the values.Cheers, Andrew

5518
Jacenda Davis
Team Member
7 months ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis
New domain not generating previews in Slack

Links on the new domain app.amplitude.com are not generating previews in slack.  

29411
Anthony
Peer Moderator
7 months ago

Recent Tips & Tricks

Terms & ConditionsCookie settings