Creating Duration Breakdown Bar Graph (histogram) in Grafana with OpenSearch DB

Grafana Dashboards
1

Hello Grafana Community,

I am currently working on replicating a Mixpanel dashboard in Grafana, and I’m facing difficulties in recreating a specific bar graph that is broken down based on duration. I would appreciate your assistance in understanding how to achieve this in Grafana with OpenSearch DB.

The desired graph should represent a breakdown of events based on different duration ranges. Each bar in the graph should represent a specific duration . The height of each bar should reflect the count of events falling within that particular duration. As you can see the mixpanel image below

image
image1868×740 54.9 KB

I have already set up Grafana to connect to my OpenSearch DB and successfully retrieved data for other visualizations. However, I’m unsure about the steps required to create the duration breakdown bar graph specifically.

Here’s what I have done so far:

image
image1387×528 43.1 KB

As you can see in the above Image. I am getting the bar graph but it is not correct. It is breaking down into types but I want the “unlock” type to break down on duration.

I am using below query

image
image1376×245 19.6 KB

Despite these efforts, I haven’t been able to achieve the desired graph with the duration breakdown. I’m seeking guidance from the community on how to approach this and configure Grafana to display the duration breakdown bar graph based on data from OpenSearch DB.

If there are any specific plugins, panels, or queries that I need to utilize, please let me know. Additionally, if there are any considerations specific to working with OpenSearch DB in Grafana, I would appreciate your insights.

Thank you for your time and support. I look forward to your suggestions and recommendations.

Best regards,
MIR AKBER

2

@mirakber Did you find anything on this topic, I want to visuals the number of users from mixpanel in Grafana?

3

That representation is histogram.

A histogram is a graphical representation of the distribution of numerical data. It groups values into buckets (sometimes also called bins) and then counts how many values fall into each bucket.

So histogram is a keyword, which you need to search. There is some doc, which may help you, e.g:

4

I’m new to grafana, how to fetch the mixpanel data into grafana ( which datasource should I install ?) and thank you