Hi:

I’ve created a file where I’m trying to do a filter according to  each concrete customer and one of his products that he has bought.

 

Now I’m trying to create a graphic with the result but I cannot get a  monthly count like in the left chart.

 

I’d like to have 3 lines, each of those describing the tend in each year, with the 12 month on the x-basis

Is it possible?

Thank you very much.

RECOUNT.fmp12

I am attaching two old demo files showing two possible approaches you could take.

In more recent versions you could also use ExecuteSQL() to gather the chart data instead of the Fast Summaries method used by the script. Note that with both methods you need to take precautions against months with no data.

 

ComparisonChartSlots.fp7 ComparisonChartScripted2.fp7

On 9/23/2021 at 6:43 PM, comment said:

I am attaching two old demo files showing two possible approaches you could take.

In more recent versions you could also use ExecuteSQL() to gather the chart data instead of the Fast Summaries method used by the script. Note that with both methods you need to take precautions against months with no data.

 

ComparisonChartSlots.fp7 60 kB · 1 download ComparisonChartScripted2.fp7 68 kB · 3 downloads

Thank you very much!!

I'll check them.