rokpalcic

Hi there! Thanks for your answer. I fixed the issue by adding a column with a unique identifier to my table (all other options were set correctly).

Thanks a million for the speedy response! I will look into this a bit more, but thank you for helping me get started!

Thanks! It’s definitely a step in the right direction. I understand now that individual columns are separated by commas. Is there documentation explaining all parameters and display customization options? For instance, how would I compare two different sets of dates from the same column (e.g. donations from 2022 vs 2023)?

Thanks,

Rok

Thanks! I have toyed around with it and managed at the very least to get the query right to display what I need (donations made during a certain period).

However, when I want to display it as a chart, I get the following message: “Not enough columns given to draw the requested chart.” I suspect this is due to the fact that I need at least one more column to compare this value to. What would be the correct syntax for it? Currently, I have

SELECT SUM(zc5_Amount)
FROM Donations
WHERE
zc5_Date BETWEEN ‘2022-07-01’ AND ‘2023-06-30’

Really appreciate the help and responsiveness!

Thanks for the quick reply and pointing me in the right direction! It does look very promising, but I fear I lack the required knowledge to get it to work. I will keep working on it and wait to see if someone else has a solution that would work for me right away.