Newbies Ixel Posted September 23, 2021 Newbies Share Posted September 23, 2021 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 Link to comment Share on other sites More sharing options...
comment Posted September 23, 2021 Share Posted September 23, 2021 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 Link to comment Share on other sites More sharing options...
Newbies Ixel Posted September 27, 2021 Author Newbies Share Posted September 27, 2021 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 941 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now