Hi there, I'm still a bit new to Knack and I'm having some trouble with something that seems simple. It involves a donations graph of amount received in pledges and cash, vs the total goal.
I'd like to generate a column-bar chart where the left side shows the Goal amount ($2,000,000). And then two bars show 1) amount pledged, and 2) amount received.
All I have is an object that has one record. The fields are: Total Goal, Amount Pledged, Amount Received, % Pledged, and % Received. The user simply has to enter the amounts into each field of that one record, that's it. No other calculations.
For the life of me, I can't get the left side (Total Goal) to show the $2,000,000 that the user enters. It will put the written label there, but it chooses it's own scale...setting the bars against $1.5 million instead. The client just wants to see their the amounts they enter on a graph compared to their total goal they entered.
Is there any way to do this? Thanks so much for any help!