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

Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis

CSV Export Contains Quotation Marks or Leading Spaces - WHY?

Hi Amplitude Community!We would like to provide context about the quotation marks or leading space in CSV exports. Our engineering team modified exported CSVs to include additional quotation and tab characters in front of all values as a preventative measure for a security risk known with CSV downloads (details here). Attackers can potentially use a formula to inject false data or leak data. And in order to prevent formula triggering cells from running, our engineering team revamped our CSV exports by prefixing quotation and tab characters in front of all values.With that being said, while that security issue remains, we received feedback from customers who said that they were willing to take that risk. Therefore, we implemented a way to export CSVs from Amplitude without any characters in front for those users. If you are willing to take that risk as well, you can enable the feature to remove the spaces in your CSV in your Org Settings section on the Profile page. You can scroll down

0
Amplitude Admin
Community Manager
4 months ago
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
posted in  Building and Sharing Your Analysis

Currency Conversion at Amplitude

Hi Amplitude Community, Amplitude currently does not support currency conversion. If you receive revenue in different currencies, then we recommend normalizing to a single currency before you send us revenue data. Amplitude logs the exact revenue value sent to us and treats it as a numerical value (not a currency value). By default, the currency sign we display in the dashboard is the dollar sign, "$".You can change this display under Organizational settings > Projects > Currency Display. Please check this doc for more information: https://help.amplitude.com/hc/en-us/articles/15581410157339. NOTE: Changing the currency display does not modify nor convert the underlying data. ----- please give this post a thumb-up if you find it helpful! This will help us know what content we should publish in the future :) -----Amplitude Team 

0
Amplitude Admin
Community Manager
4 months ago
Amplitude Admin
Community Manager
Amplitude AdminCommunity Manager
published in  Building and Sharing Your Analysis

Welcome to the building and sharing your analysis forum!

Learn, ask questions, and help others use and build Amplitude charts to gain valuable insights! This is where you can ask and get feedback on questions such as: ✅ How can I calculate DAU/WAU?✅ How can I see the distinct count of devices for users?✅ Why is the conversion rate in my Conversion chart higher than the conversion rates in my Conversion Over Time Chart?✅ How do I calculate the bounce rate?✅ How do I look for users who did not perform an event? Helpful resources: ❓Working with charts: getting started with our charts, advanced topics and semantics of our charts, FAQs on specific charts❓Organizing and sharing your charts: collaboration within your team, and sharing analyses outside your organization❓Advanced analysis tools: cohorts, account-level reporting, cart analysis, sampling, and more❓Amplitude Academy course: Getting Started with Analytics❓Amplitude Academy course: Increase Data Use across your Organization with Amplitude's Collaboration FeaturesStill have questions? Post

10470
Amplitude Admin
Community Manager
11 months ago
M
markohlebarNew Member
asked in  Building and Sharing Your Analysis

Max parameter data size for an event

Hi guys, we’d like to know what is the maximum character length is for the parameters we attach to an event? We’d like to use this info to limit the amount of chars on the frontend to a sensible length. Couldn’t find this info in the documentation nor in public headers, so it might be prudent to add it there as well. 

4
Anthony
Peer Moderator
1 day ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis

Support AI Chatbot

I just saw a new Amplitude Support AI Chatbot (very GPT-like), but now I can’t find it again. Does s/he have a name? How can I find it to use it again? Here’s a partial screenshot of it’s response to a question from 10 minutes ago:   

0
Anthony
Peer Moderator
2 days ago
B
Benjamin WiegandNew Member
asked in  Building and Sharing Your Analysis

How to plot the evolution of mean aggregated event count on user timeline

Hello, I’m new to amplitude and I’m trying to recreate a plot we made with our legacy custom analytics scripts: we’re interested in how often users performed a specific event on average (= y-axis), grouped by how many days ago the users signed up (= x-axis). With this, we want to see how the typical user lifetime looks: how many days after signup do they start doing something (on average), how many days after signup do they stop doing something, etc. Is there a way to build such a chart in amplitude?Problem with Segmentation tool is that it just counts events grouped by calendar dates. I couldn’t find a way to make it group event counts with respect to the user’s timeline (days after signup).I also managed to get a histogram of event counts, but I was unable to plot the time evolution of average event count, grouped by days after the user’s signup event. Is there a way to do this in amplitude? Thanks in advance! :)

0
B
2 days ago
C
charlotte de thiersantNew Member
asked in  Building and Sharing Your Analysis

Create a funnel with condition "completed 1 day AFTER" rather than "WITHIN a day"

Hello dear communityI am trying to create a funnel but rather than having the condition “completed WITHIN 1 day” i would like to have “completed the day AFTER the first event”Is it possible?Thanks a lot for your help!Charlotte

1
Saish Redkar
Expert
2 days ago
N
Nadav MillsNew Member
asked in  Building and Sharing Your Analysis

Sending alerts to slack?

is there any way sending Product Monitor Alerts to slack instead of email?

3
JennRu
Community Manager
3 days ago
C
Congxing CaiNew Member
asked in  Building and Sharing Your Analysis

How to measure conversion rate of invites?

I am not sure which chart type to use here, given the two events would be logged for two different users:invite event is sent by user A accept invite is received by new user BThanks!

5
Saish Redkar
Expert
3 days ago
aleksandar
aleksandarNew Member
posted in  Building and Sharing Your Analysis

How to Create Dynamic Cohorts Based on Stickiness

Hi everybody!TL;DR: This guide explains how we solved our use case of needing dynamic cohorts based on stickiness. The solution involves combining derived properties and distinct values of property option for counting events in a cohort definition. At my workplace, we use stickiness to classify user engagement levels (e.g., a casual user is someone who uses the product for one week in a month, and a power user is someone who uses the product for three or more weeks in a month). We've been struggling to incorporate stickiness-based engagement into our dynamic cohorts, which are essential for our analytics.Recently, we found a good enough solution to our use case by combining derived properties and distinct values of property options for counting events in a cohort definition.1) To create a derived property that returns a numeric order of a week in a year, we used the Amplitude property `Server Upload Time` and transformed the timestamp to a week number using the following formula:`Week

3
C
Conversationalist
5 days ago
C
Conversationalist
ccanamasConversationalist
asked in  Building and Sharing Your Analysis

Tracking Power / Core / Casual user engagement states over time

Hi,We have defined the following:Power User = fires event A on 5 or more distinct days of the weekCore User = fires event A between 1 and 4 distinct days of the week Casual User = fires event A at least once a month, but not frequently enough to be a Core or Power userDormant User = Has gone more than 30 days without firing event A I am trying to create a chart that has weekly cadence, and shows me how my user population breaks down into these categories over time. Something like below (incorrect definitions used for the screenshot, but just wanted to convey what I envision the final product looking like). Week to week, if a user’s behavior changes, they would be represented in a different category. Which category a user is in for a given week depends only on the behavior they showed during that week (or during the last 30 days relative to that week if we’re talking about Dormant category). I tried using Behavioral Cohorts first, since I know there is an option to use “count in interva

0
C
Conversationalist
5 days ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

Switching holding constant in funnel analysis

Hi, I want to build a funnel of how users grow the user base by inviting others and if these new users actually finish any action. ImagineUser A creates playlist User A invites new user B to playlist (New User B creates an account) New user B plays song in playlistI can do this by the holding constant of the playlist id, but I would not know if the final play in the playlist is User A, B, or C (should only be user B) in this case.

9
K
5 days ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis

What's the fastest way to search?

I’m trying to find the fastest loading webpage in Amplitude that I can bookmark if I know I want to perform a search and want to get a search bar asap. Is there a way to bookmark the “Advanced Search” functionality? The webpage google.com is a good example of quick access to search 😀. In less than half a second, a search bar appears and the cursor already in the search field. 

1
Saish Redkar
Expert
8 days ago
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis

PROPSUM (and other props formulas) uses unique or total?

Hello there! I am building a dashboard that shows the amount in $$ that we generated and I want to use the PROPSUM formula for that. My business case is that a unique user can generate $$ more than one time, so I need to know if it's safe to use PROPSUM to account for the TOTALS and not Unique.Thanks in advance!!

1
Saish Redkar
Expert
8 days ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis

Circle Markers here to stay? (Dots on the lines in Segmentation)

These circle markers started showing up in segmentation and in dashboards. Are they here to stay? Possible to turn them off?   

3
Saish Redkar
Expert
8 days ago
S
Novice
Simon HiltonNovice
asked in  Building and Sharing Your Analysis

Percentage of accounts who have greater than x users performing an event.

We are trying to move out metrics to be more account based following getting the accounts add on. Many of the metrics we want to measure are structure like % of firms who have at least X users performing Y action. How can we build something like that?

2
Saish Redkar
Expert
9 days ago
E
Etai FiedelmanNew Member
asked in  Building and Sharing Your Analysis

Custom formulas

Hi everyone,Any ideas what formula shows only users who conducted a specific event 4 weeks in a row?Thanks,Etai

2
E
10 days ago
M
Conversationalist
Mauricio.CastroConversationalist
asked in  Building and Sharing Your Analysis

Graphs with different timeframes in the same report

Hi there! I have a report that it contains two graphs:Daily Accounts Opened Where I group by the number of applicants in that account and show it in a bar graph All Time Accounts Distribution Where the distribution is related to the number of applicants in that account   I want to show the daily performance and also the all time performance BUT my report is making all views to show as daily. I wanted the report to follow the timeframe I've set in the graph. Is there a way to do it? Thanks in advance

4
M
Conversationalist
10 days ago
A
AshikaNew Member
asked in  Building and Sharing Your Analysis

Segmenting users by those who performed an event “any time within 1 day of first use”

I am attempting to segment a funnel chart by user properties. I see in the FAQ page that user properties are only applied to the first event in the funnel. In my case, the first event in the funnel is user sign up, so the property I want to segment doesn’t exist yet. One way I tried to combat this is by adding a segment of users who performed “Any active event” with the property: To validate this, I added a segment of users who performed “Any event” without any properties filtered out. In this image, I would think segment 1 and segment 2 would be identical (since all users who go through the funnel should have performed an event within 1 day of first use?) Why are these two segments different?

0
A
10 days ago
Anthony
Peer Moderator
AnthonyPeer Moderator
asked in  Building and Sharing Your Analysis

Missing chart title in redesigned chart controls

Is it just me or are the new redesigned charts missing the chart titles?  Expected design with chart title Actual design missing chart title  

13
Anthony
Peer Moderator
11 days ago
S
Novice
Simon HiltonNovice
asked in  Building and Sharing Your Analysis

New users who never come back

Hey all, This is probably a simple one but how can we track people who come to our app once and never come back?We have a login event but not sure how to limit it to people who never come back. Thanks

3
A
Experienced
11 days ago
H
Helpful Hero
Herb LauHelpful Hero
posted in  Building and Sharing Your Analysis

"Row Totals/Sums" more available?

 As referenced above, Row sums/totals can be quite useful in what my organization uses regularly.While I (on some level) I can understand why it’s not an option for totaling unique users (although allowing totaling with the understanding about de-duping is preferred), it would be quite helpful if row totals could be available across more charts/tables/etc. in Amplitude, if not at the very least in event totals.  For my specific organization, the ability to sum up totals across multiple smaller time periods into a larger time period is quite helpful.

0
H
Helpful Hero
11 days ago
L
Leonardo AdrianoNew Member
asked in  Building and Sharing Your Analysis

[Dashboard Issue] Dashboard is exporting PDF and PNG with no data

I'm having an issue exporting a saved dashboard to a PDF/PNG; the PDF/PNG shows up without data. This feature worked fine until last week (I’m using the Slack subscription). I went to the dashboard to see, and everything was showing fine, but when I downloaded it, the outline of the data cards was there, but there was no data or images inside the cards. Seems to be related to this​​​​​​

0
L
12 days ago
Q
quintinparNew Member
asked in  Building and Sharing Your Analysis

Cohort with two time – calculating Viral K

I am in the process of building a Viral K table I have an event referralShared that triggers when a new unique URL is created for sharing invites. Another one referralSuccessfulAccept whenever an install happens post clicking a referralShared URL. To calculate Viral K, the referralSuccessfulAccept should be a week delayed from the referralShared creation. i.e., if I were to look at the Viral K for this week, it should only show last week’s referralShared and this week’s referralShared and compute. It should REMOVE all referralShared for this week. How do I achieve this?

0
Q
12 days ago
C
cbrownNew Member
posted in  Building and Sharing Your Analysis

PDF Export of Saved Dashboard Issue

I'm having an issue where if I export a saved dashboard to a PDF, the PDF is showing up without data. This feature worked fine as recently as the beginning of Jan. When I download the PDF, the outline of the data cards are there, but there is no data or images inside the cards.When I export as PNG, the data shows up fine.

3
L
12 days ago

Terms & ConditionsCookie settings