I am working with charts in filemaker and since it is my first time working with them, i am kind of stuck with them.
I know how to do simple charts but i can not get the result i want with dynamic charts.
For example i have a field where i select the information i want to show in a chart based on invoice months.
So if i select last 6 month i get the first 6 months of the year and i can show them in the chart but i want to show the total of priced invoices during this time based on months, which i can not (its just empty, i tried with sql but not working).
i have also sorted and created reports but not the charts.
I will attach 2 photos of what i mean.