Skip to main content
Solved

Stacked Bar Chart from two different properties of the same event

O

Hey, 
I am trying to create stacked bar chart from two properties of the same event.

I have two custom properties:

  1. perfTime - total application loading time
  2. requestProcessingTime - this is only backend part ot total loading time

If I use only single property everything works great but I would like to add to total time bar a second bar showing request processing time.

I know that stacked bar chart can be created with two different events like here:

But the question is if there is a way to do that with only one event.

What I have:


What I would like to have:
 


Thank you​​​​​​​

Best answer by Jeremie Gluckman

Thanks for posting here @omygoodness To create a stacked bar chart from two properties of the same event, you can use the Amplitude Chart Editor. In the "Group By" section, select the property you want to use to group the data (in your case, this would be the "perfTime" property). Then, in the "Split By" section, select the property you want to use to split the data into two bars (in your case, this would be the "requestProcessingTime" property). Choose "Stacked" as the bar chart type.

View original
Did this topic help you find an answer to your question?

6 replies

Jeremie Gluckman
Team Member
Forum|alt.badge.img+9

Thanks for posting here @omygoodness To create a stacked bar chart from two properties of the same event, you can use the Amplitude Chart Editor. In the "Group By" section, select the property you want to use to group the data (in your case, this would be the "perfTime" property). Then, in the "Split By" section, select the property you want to use to split the data into two bars (in your case, this would be the "requestProcessingTime" property). Choose "Stacked" as the bar chart type.

A
  • Amp
  • New Member
  • 1 reply
  • June 26, 2023

Hi @Jeremie Gluckman I can’t seem to find the “Split By” section, could you please show me with a screenshot? Thanks!

J
Conversationalist
Forum|alt.badge.img
  • Josh K
  • Conversationalist
  • 6 replies
  • July 13, 2023

Hi @Jeremie Gluckman , like @Amp I cannot find any ‘split-by’ option in the grouping. Selecting both properties as group-by just gives a stacked bar with all available options instead of grouping them horizontally by one metric and vertically by another. Can you please confirm whether or not ‘split-by’ is still available? Thank you

J
Conversationalist
Forum|alt.badge.img
  • Josh K
  • Conversationalist
  • 6 replies
  • July 13, 2023

If I click on the specific prop and follow the popout menu to “Data” I get a modal for the prop with the last tab saying ‘splitting’ but nothing ever shows up there. I assume this wouldn’t be the right place...

J
Conversationalist
Forum|alt.badge.img
  • Josh K
  • Conversationalist
  • 6 replies
  • July 24, 2023

Hello, was hoping for a reply to this either confirming that the feature is broken, or explaining how to achieve a stacked bar with specific items being stacked and grouped

JennRu
Community Manager
Forum|alt.badge.img+9
  • JennRuCommunity Manager
  • Community Manager
  • 75 replies
  • September 20, 2023

Hi all, I believe Jeremie meant add the 2nd property as another group by on the event. The terminology “split by” doesn’t exist in Amplitude, but this concept is synonymous to grouping by a property. 


Note: the stacked bar chart is not available when performing a formula. So this will need to remain a bar chart visual. 

Jennifer Rudin
Saish Redkar
1 person likes this
  • Saish Redkar
    Saish Redkar

Reply


Helpful Members this Week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings