Bar chart with percentage

Grafana Bar Chart Panel
1

Hi, I would like to have a time series chart, with bars, which displays a value over time and also how that value is composed in % by its sub-categories.

For example: income from cars selling:
1 March, $45000, (30% AUDI, 50% BMW, 20% MERCEDES)
2 March, $25000, (10% AUDI, 80% BMW, 10% MERCEDES)

Hence I would like that the height of the bar to be a representation of the income (es. $45000) and the bar itself to be divided into its three colors/categories (AUDI; BMW and MERCEDES), respecting the percentage.

2

Welcome @glatorre
Can you provide details of your datasource where this data is being stored, and some of the sample data?

3

Hi, I’m using mongodb where each document currently is in this form:

{
    "value" : 45000,
    "timestamp" : 1678709584000,
    "car_brands":[
    	{
    		"name": "BMW",
    		"perc": 10
    	},
    	{
    		"name": "MERCEDES",
    		"perc": 10
    	},
        {
    		"name": "AUDI",
    		"perc": 80
    	}
    ]
}

Anyway I have full control of my data model and I can modify it if necessary

Thanks

4

Hi @glatorre,

I used a testDB data to simply fill in some values and then use the Unit option as a percentage and then it shows the values in a percentage format.

image
image1912×418 43.6 KB

I hope this helps.

5

That does not look accurate: 3000%?

6

It’s based on csv values which are not real but if the user does have values in the range of 0 - 100 then with unit option can display the percentage.

This is to what I understand he wants to display unless provide some more feedback,

2 Likes