Bar chart next to the table

Hi, I was asked to include a bar chart in addition to the table next to it. Is it possible to generate such a chart from the same data as in the table? The data will be downloaded from my database, I have the tables but I can’t find anything for the chart. Can anyone help me?

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Hey @Voleniusz,

Welcome to the community :cake:

It would be great if you could include some more information but if you are just trying to create a chart you could try the Quickchart node we have to see if that does what you need it to.

image

I found this tool, but I can’t play anything on it. The effect is shown in the picture.

Hey @Voleniusz,

Sadly to provide any more help I will need more information, Do you have sample data or a workflow you can share that might help?

Yes, I can provide the data I get from my database in json format.
[
{
β€œData”: β€œ2022-11”,
β€œ123”: β€œ126”,
β€œABC”: β€œ128”,
β€œASD”: β€œ129”,
β€œQWE”: β€œ109”
},
{
β€œData”: β€œ2022-12”,
β€œ123”: β€œ94”,
β€œABC”: β€œ129”,
β€œASD”: β€œ107”,
β€œQWE”: β€œ91”
},
{
β€œData”: β€œ2023-01”,
β€œ123”: β€œ132”,
β€œABC”: β€œ117”,
β€œASD”: β€œ132”,
β€œQWE”: β€œ123”
},
{
β€œData”: β€œ2023-02”,
β€œ123”: β€œ94”,
β€œABC”: β€œ245”,
β€œASD”: β€œ127”,
β€œQWE”: β€œ131”
},
{
β€œData”: β€œ2023-03”,
β€œ123”: β€œ85”,
β€œABC”: β€œ260”,
β€œASD”: β€œ153”,
β€œQWE”: β€œ163”
},
{
β€œData”: β€œ2023-04”,
β€œ123”: β€œ72”,
β€œABC”: β€œ249”,
β€œASD”: β€œ152”,
β€œQWE”: β€œ243”
},
{
β€œData”: β€œ2023-05”,
β€œ123”: β€œ79”,
β€œABC”: β€œ238”,
β€œASD”: β€œ99”,
β€œQWE”: β€œ132”
},
{
β€œData”: β€œ2023-06”,
β€œ123”: β€œ109”,
β€œABC”: β€œ308”,
β€œASD”: β€œ138”,
β€œQWE”: β€œ139”
},
{
β€œData”: β€œ2023-07”,
β€œ123”: β€œ84”,
β€œABC”: β€œ136”,
β€œASD”: β€œ181”,
β€œQWE”: β€œ155”
},
{
β€œData”: β€œ2023-08”,
β€œ123”: β€œ60”,
β€œABC”: β€œ221”,
β€œASD”: β€œ137”,
β€œQWE”: β€œ239”
},
{
β€œData”: β€œ2023-09”,
β€œ123”: β€œ89”,
β€œABC”: β€œ310”,
β€œASD”: β€œ164”,
β€œQWE”: β€œ119”
},
{
β€œData”: β€œ2023-10”,
β€œ123”: β€œ104”,
β€œABC”: β€œ320”,
β€œASD”: β€œ108”,
β€œQWE”: β€œ294”
}
]

What are you trying to do with that data? What are you expecting the end result to be?

the end result is the same as in the picture above. Is it possible to make this type of n8n names?

Hey @Voleniusz,

It should be possible to create something like that although to be honest having played with the Quickchart node I am not sure how it actually works so I think I need to spend some time with it to work it out, For now you could do it manually using the Quickchart API. The workflow at the bottom will email the image below which looks close to what you are after.

Damn it works. I get what I wanted thanks to your help. However, is it possible for me to send an e-mail with the table and this image next to it? Can you help me further on this matter?

Hey @Voleniusz,

The table itself might be tricky but it looks like the HTML node has an option to convert to html table which might do the job.

overall the problem is this chart. Because when I send the table itself, I have it nicely in my e-mail. But I don’t know how to add this chart next to it. Will you help?

1 Like

I am battling with the quickchart node too - there seems to be very little info on it. I’m trying to fathom it out using the quickchart examples but not winning.

To go a different route - maybe it would be better to create the full quickchart API url call … any pointers re how to build a URL?

Well, you know, I already have a chart.
I also have the table I am looking for. The problem for me is how to combine these two things so that they are sent in one e-mail.

Hye @emeyedeejay,

Welcome to the community :cake:

The example workflow above uses the quickchat api so would work as a good starting point.