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
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.
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?
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
The example workflow above uses the quickchat api so would work as a good starting point.