2. PHPRunner General questions
  3. Help build a chart
This topic is locked

Help build a chart

 		6/13/2022 1:45:21 AM
PHPRunner General questions
V
 Vova Zlo author

Hi, I need help with the chart.
Let's say I have three tables.
tbl_payments with rows (paymentID, UserID, paidDate, amaunt, orgID).
tbl_organization with rows (organizaationID,orgName).
tbl_budget with rows (budgetID, userID, orgID, color).
Every user has their own set of budget records where saved information about the organization. The table payments have records of every payment to the organization. I want to make a chart that shows the sum of every year, divided by the organization and showing the total. Sorry about my English. Please look at the picture, the chart must be something like that.
I will be grateful for any help.

img alt

Sergey Kornilov admin 6/16/2022

Vova,

could you explain what exactly causes the trouble building this kind of chart? How does you data look?

Did you also check this article: Using SQL to shape chart data?
V
 		Vova Zlo author 6/24/2022

img alt

The name of the organizations, colors, and amounts in the table and on the diagram I drew above do not match, this is just an example.
Sergey Kornilov admin 6/25/2022

Still not clear what causes the trouble. Did you write the SQL query that combines data the required way?

V
 		Vova Zlo author 6/26/2022

I tried, but nothing worked. That's why I asked for help. Not enough brains. I can collect the data, but the correct chart does not work.