Hello
I am trying to make a fusionchart visualization and so far i can display the value i need but my problem now is that i dont know how to tell to each element to calculate from day 1 to the month the the last. I get all the same totals on each column. So basically i need to tell to element 1 to check only the values from january to element 2 the values from february and so on. I do have a date field on my form so it should be looking that element to make this calculation.
I was thinking maybe a hidden calc element that sums all up and gives me a total but then again i dont know how to tell how to get the sum values of a specific month only.
I hope i have made myself clear, if not please ask. Thanks in advance for your patience and time.
I am trying to make a fusionchart visualization and so far i can display the value i need but my problem now is that i dont know how to tell to each element to calculate from day 1 to the month the the last. I get all the same totals on each column. So basically i need to tell to element 1 to check only the values from january to element 2 the values from february and so on. I do have a date field on my form so it should be looking that element to make this calculation.
I was thinking maybe a hidden calc element that sums all up and gives me a total but then again i dont know how to tell how to get the sum values of a specific month only.
I hope i have made myself clear, if not please ask. Thanks in advance for your patience and time.