Bar chart not grouping by month?

Question

Is there a reason the bar chart doesn’t divide out into months’ data?

The line chart above doesn’t seem appealing visually to my end users.

The bar chart, for whatever reason, doesn’t seem to want to divide into groups based on the month.

The time controls at top right are for Since July 1, so for the current day, I’d hope for July, August, September, with September having less since it’s a partial month. There also don’t seem to be Amplitude event properties based on the time stamp of the event visible within the event options, so I can’t run some kind of calculated field on the month of the time stamp.

The 2 time options available for Group By seem to be Hour of Day and Day of Week, which are nice to know, but not as helpful to the end user.

icon

Best answer by JennRu 20 September 2023, 22:10

View original

JennRu · Accepted Answer

Hi @Herb Lauthank you for sharing these screenshots. Have you tried plotting the chart visual as a stacked bar? This will display the count of users who performedthe event as a bar for each respective month in your chart.Here’s a sample chart in the Amplitude Demo. I included screenshots below if you have any issues opening the link.Use Stacked Bar chart visual in Event Segmentation to breakdown view per time interval e.g. monthly, weekly, daily, etc.For your question on timestamps, Amplitudecollects and enables filtering on the Server Upload Time, whichis the timestamp that Amplitudereceivedthe data. So if your org is backfilling any historical data, the server upload time will display when the data was ingested in Amplitude, not the backdated timestamp. But you can use this for filtering for each month’s ingested event counts.Sample chart:https://app.amplitude.com/analytics/demo/chart/y7csixu6User Server Upload Time to see specific bars of users who performed an event for each month, based on Amplitude’s event ingestion time recorded.Note: You’ll visibly see if your company is backfilling data if you use the Server Upload Time filters from the chart above and switch to a stacked bar chart and see multiple colors for each month, like the screenshot below.This demo org is backfilling data for July in the month of August, and for August in the month of September.Let me know if this helps, thank you

Herb Lau · Answer

@JennRuThank you, stacked bar did it, that was the one I didn’t try.That being said, why would stacked bar fix it?the logic doesn’t fit, since each bar doesn’t need to be divided into groups.