Need to create a bar graph for customers who are having sales less than previous month

[Abj_Ins]

Hi Team,

Need to create a bar graph for customers who are having sales less than previous month. Here we need departments on X-axis.

Thanks.

[carly.richmond]

Hi @Abj_Ins,

Are you able to share what your data looks like?

[Abj_Ins]

Thanks @carly.richmond for the response, here is the sample data for your reference.

Department Code	Sales	Date
10	32	21/03/2023
10	12	22/03/2023
20	56	20/03/2023
10	67	23/03/2023
30	98	19/03/2023
20	43	14/03/2023
20	65	18/03/2023
30	98	19/03/2023
30	10	17/03/2023
10	89	21/02/2023
10	98	22/02/2023
20	87	20/02/2023
10	21	23/02/2023
30	14	19/02/2023
20	21	14/02/2023
20	87	18/02/2023
30	43	19/02/2023
30	44	17/02/2023

Thanks.

[Marco_Liberati]

I would suggest in this case a dashboard with a couple of panels in a dashboard:

• a first panel to see the trend of sales for all departments
• a second panel with a breakdown metrics by department with a ratio value and dynamic coloring by value

Here's a simple example I've put together (in your case departments can be used in place of categories here):

Note the fixed time range on the metric to make sure to always apply 1 month to it.

As for the metric configuration:

For the Current / Prev month I've used a formula with a shift: count() / count(shift='1m') (but you might consider also monthly revenues (still using shift, but use the operation you prefer in place of count()).

As for the coloring, I've set 3 stops:

• > 1 green for ok
• 0.8 < x < 1 yellow for not so ok
• < 0.8 red

[Abj_Ins]

Thanks @Marco_Liberati for your quick response.