Building and Sharing Your Analysis

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

  • 848 Topics
  • 2,259 Replies

848 Topics

aleksandar
aleksandarNew Member
posted in  Building and Sharing Your Analysis

Is there a way to filter user segmentations by newest user property?

Hi everyone, I'm wondering if anyone knows of a solution for filtering user segmentations by the newest (current) user property in Amplitude. I've run into some use cases where this feature would be really helpful, but I'm not sure if it exists.Amplitude's analyses are event-based, which means that filtering in charts is based on the properties at the time of the event. However, there are times when filtering or grouping by current user properties would be more useful. ExamplesHere are a few use cases where we've had a need for such filtering:A) User origin data comes from a third-party integration - sometimes our engineering team has to enrich user properties after the actual time of the event. For example, an event resembling the sign-up of a user will not contain all properties needed to determine their origin. Thus, filtering in this particular event will return "(none)" for such users.B) In-depth breakdowns of users' origin can become very detailed very quickly, and various combin

2
aleksandar
11 months ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

MRR per user

Hi, I want to analyse how much MRR we have per user per month. For this I have a property on group level (customer) that states the MRR.I also have the number of users by looking at “Any Active Event” Uniques.But I cannot divide the “sum of all MRR” by the “number of users” because I would need to propsum the MRR by grouping by the customer, but only on 1 event per customer per month. If I do this on any event that occurs more often than once MRR is summed up for each of these events instead of once per customer.

0
K
Well-Versed
11 months ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

Average over all groups

We group our users into “customers” in the Accounts Addon in Amplitude, given we are a B2B service.Now I would like to understand the average number of new users (there is an event “user created” for that) per customer.Meaning, NOT the rolling average of each customer’s new users. But the average across the customers. So the average of CustomerA:5, CustomerB: 10 → 7.5 new users.

7
jmagg
Team Member
11 months ago
A
Alon YehezkelNew Member
asked in  Building and Sharing Your Analysis

Creating a funnel for disableCookies users with redirect

Hi everyone!I’m trying to create a funnel of events while there is a redirect in the flow. Im experiencing a big drop probably because users don’t acces cookies and we are running with the disableCookies option.Specifically, the redirect happens after user registration.What are my options to keep track of users, regardless of saving cookies?Thanks!

3
A
11 months ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

Optional steps in funnel analysis

Hi, we have a funnel where one step is optional for some users - meaning the windows does not even show up. If I add the step to the funnel, the users who don’t see the window the conversion drops to zero from there onwards.I’m wondering if I could mark that step optional or if I have to create different funnel charts?Thanks!!

2
G
Novice
11 months ago
D
drewhNew Member
asked in  Building and Sharing Your Analysis

Date Comparison Not Working

According to the documentation https://developers.amplitude.com/docs/identify-api, I should be able to make date comparisons if in the format ‘YYYY-MM-DD’. I have enriched a few test users with an identify API call that adds some fields in that format, yet I cannot seem to figure out how to make those fields usable in any sort of analysis. (Ex: select all users who performed any event where this date field is greater than or equal to a date that I input). It just shows nothing. Am I doing something wrong within Amplitude or is the data I’m sending possibly in the wrong format?

8
franciskafyi
Team Member
11 months ago
S
Novice
Song HaNovice
asked in  Building and Sharing Your Analysis

Blank page and error when sending member invites

I invited another member of my team to Amplitude; they received their invite but when they clicked on the link in the email it takes them to a page that loads blank and gives the error: ERR_SSL_KEY_USAGE_INCOMPATIBLE. See screen shot below. We have tried using Chrome, Safari, Edge, and clearing the cache. I have already invited two other members who have not had issues with their invites. Does any one know what might be causing this issue? 

3
Esther Trapadoux
Community Manager
11 months ago
K
Well-Versed
kornelius
asked in  Building and Sharing Your Analysis

Adding a constant line in segmentation

I want to illustrate a target value / “corridor” on a segmentation chart. Is there a way to print a static horizontal line at a specific value?

3
K
Well-Versed
11 months ago
L
Lauritz NorløffNew Member
asked in  Building and Sharing Your Analysis

Tracking users search input/queries from my website

Hi, I’m new to amplitude and can’t seem to track results from our search function on our website.I’ve tried creating events where “page url=..” without luck. I would like to organise the search results to get a better understanding on what the users want on the website, and a counter to what the most popular search words are etc. Thanks

1
Saish Redkar
Expert
11 months ago
S
Conversationalist
srushti.wadekarConversationalist
asked in  Building and Sharing Your Analysis

Perform calculations & Computations - Event Segmentation

I’m trying to perform complex calculation (weighted percentage) in Event Segmentation for which Formula cannot be used. I was wondering how can that be done.One way was to download dashboard data to csv and do further processing in Excel.Two main questions:Perform complex calculation (weighted percentage) in AmplitudeHow can I export multiple charts to one csv file ?

2
S
Conversationalist
11 months ago
M
morningdyjNew Member
asked in  Building and Sharing Your Analysis

Error with uploading csv for cohorts - none of the upload user id matches

Hi, I was uploading a list of User IDs to create a cohort and received the following message The file is well-formatted with one user id per line and no extra line/text/space. Any idea why? Thank you.

8
Esther Trapadoux
Community Manager
11 months ago
G
Gloria Deng
asked in  Building and Sharing Your Analysis

How to interpret offset in the date range?

Hi, I am working on a compass chart and having a difficult time to understand when and how to use this offset feature. Does someone have experiences using this feature? 

1
Gregor
11 months ago
JennRu
Community Manager
JennRuCommunity Manager
published in  Building and Sharing Your Analysis

Learn how to investigate your org's Monthly Tracked Users (MTUs)

This article is a guide to empower Amplitude users to investigate MTU overages. Refer to this article for any MTU billing questions. Refer to these best practices for guidance on how to set User ID tracking.If you have any concerns on your current MTU usage for the current month or last month, review the details below on how toIdentify your org’s MTU usage for the current month Data exploration on backfills, anonymous users, and project deletion Step 1: Identify backfilled data Step 2: Identify if anonymous users are spiking MTU counts Step 3: Analyze the time series of anonymous users triggering events Step 4: Identify which events are most commonly generated by anonymous users Step 5: Verify if any projects have been deleted Event cleanup tips to reduce MTUs Identify your org’s MTU usage for the current month Login to your Amplitude account and navigate to the settings < general tab.In the top right, you can view your account’s MTU usage this month and last month, alongside y

10861
belinda.chiu
Team Member
11 months ago
Eric I
Eric INew Member
asked in  Building and Sharing Your Analysis

How do I retrieve my certification/certificates?

@amplidude In 2022, I worked for one of your partner agencies. While there, I earned my “Amplitude Certified Insights Expert” certification.Having departed from this agency, I’d like to know how to retrieve my certification/certificates.Please advise.Thank you,Eric Itzkowitz

2
Eric I
11 months ago
G
glennleesidekickerNew Member
asked in  Building and Sharing Your Analysis

Listing event data

Hello,In Amplitude, I have an event, which has two event properties, both of which are date/time property types. What I’m trying to do is segment instances of this event into two groups (based on another event property). Then, I want to look at the elapsed time difference between the two timestamps properties for every event entry, per segment and then average these out.If I can’t do this in Amplitude, a download of the raw data in CSV would be preferred, so I can do in Excel/Sheets.Sorry if there is a simple way to do this, but I’m new to Amplitude and have not discovered this yet.Also for context, I’m on the free Starter plan as well.Thanks in advance,Glenn

2
N
Well-Versed
11 months ago
M
Experienced
Mridul SharmaExperienced
asked in  Building and Sharing Your Analysis

Are custom event properties removed from the chart filter option?

I am not able to filter out charts data based on event properties (custom properties) from quite some time now. Only some of the default event properties are available and I can see all of the user properties.

7
belinda.chiu
Team Member
11 months ago
B
Conversationalist
B AnalyticsConversationalist
asked in  Building and Sharing Your Analysis

Overall total is less than the sum of the rows

When I create a data table in Amplitude that looks at uniques page views, the Overall row is less than the sum of all the rows below. Surely these two should equal one another?Please can you advise? Many thanks!

3
B
Conversationalist
11 months ago
aalqaroot
Experienced
aalqarootExperienced
asked in  Building and Sharing Your Analysis

How to protect externally shared dashboards?

Hello,  We use the externally shared links to view only dashboard with clients extensively. One concern is that anyone with the URL and password can access/view the dashboard. Is there a better/secure way to manage shared links to dashboard? Can we have added authentication that can be managed by us or our clients in order to allow users to access those dashboards? 

5
aalqaroot
Experienced
11 months ago
T
Tim BroderNew Member
asked in  Building and Sharing Your Analysis

Change day of the week that weekly reporting starts on?

Our marketing cycle runs Sat-Fri.  In a segmentation report, is it possible to change these day ranges to start on Sat instead of Monday? It’s ok if this is a global setting somewhere  

3
A
11 months ago
J
jhong_autofiNew Member
asked in  Building and Sharing Your Analysis

Exports Showing Events from 2 Months Past

My team export data into an S3 bucket on a daily basis to share with our partners. They are stating that when they pull these files for analysis, they are seeing click events that occurred up to 2 months past.  Has anyone seen anything like this or know of why this could happen? 

1
Esther Trapadoux
Community Manager
11 months ago
D
dan_at_soonaNew Member
asked in  Building and Sharing Your Analysis

unhiding an event is not working, the event is not showing up in analysis builder

I accidentally changed the visibility of a view events and it caused them to disappear from the event selection in the report builder.  How long does it take for these events to reappear? 

2
Esther Trapadoux
Community Manager
11 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

2
Esther Trapadoux
Community Manager
11 months ago
B
BoFredrikNew Member
asked in  Building and Sharing Your Analysis

Error when loading embedded chart in Google site

I have a built a Google Site for my workplace internally and have embedded a number of Amplitude Graphs there. I have nothing more there than the graphs and a few headlines in the page. But most often the graphs can’t load and I see this instead. I can sometimes see the graph for a second before the error screens show instead. What can I do to fix this?This is the error view that I see for most of the graphs, every time the site load.This is what it should look like, and sometimes do. 

1
Esther Trapadoux
Community Manager
11 months ago
I
ivanmunizNew Member
asked in  Building and Sharing Your Analysis

I don´t see event date properties.

Hi there!I want to create MTD reports like: (Number of purchases this month - number of purchases last month)/Last month purchases * 100). The problem is that I can´t find how to group the events by dates, like Purchases between 03/01/2023 and 04/01/2023 or something like “Last Month”. We are sending data from Segment, could that be the problem? In any case I can see some derived properties that don´t work for my case neither: https://analytics.amplitude.com/demo/chart/new/ld62bjjThanks!

3
Esther Trapadoux
Community Manager
11 months ago
R
rajesh.kumarNew Member
asked in  Building and Sharing Your Analysis

Getting alert popup in Web Platform

Hi Amplitude Team,I am getting alert popup related to the browser SDK during script loader time.caught TypeError: Cannot convert undefined or null to object    at Function.keys (<anonymous>)    at analytics-browser-1.9.1-min.js.gz:1:79558    at analytics-browser-1.9.1-min.js.gz:1:79749    at analytics-browser-1.9.1-min.js.gz:1:79752 Can you fix this soon.

1
Esther Trapadoux
Community Manager
11 months ago

Terms & ConditionsCookie settings