speleo

Turns out the API was restricted. As soon as I removed that everything worked as normal again. Many many thanks for your support!

Seems the second part of my issue is around the Google API credentials.

The instructions here look outdated as I see no option for user type: external. https://docs.simplecalendar.io/google-api-key/

The only options I have are oAuth and Service Accounts. While this might be a quick config the options are non trivial. Does your FAQ need a revamp?

Thank you for the super quick response. The site is no longer thowing an error, but right now the calendar content is not showing. I will investigate futher later today however I am short on time right now. Many thanks!

Perfect – fixed for bar charts too.

Also I like the new layout of Step 3 in the backend.

Thank you for a very quick response and fix. Most appreciated.

The line graph is fixed but the issue is still there for bar graphs. Could you fix that too please?

If you turn on the option “Show table-view data below the graph“, you’ll see that all the data is listed as starting from the same start date. In this case 1943.

Data set 1 runs from 1943-today however the other data sets start later but are tied to start in 1943 as the x axis is ignored and just assumed to be sequential. Which it isn’t.

If you run the queries one by one in phpmyAdmin you’ll see the issue.

Many thanks!

• This reply was modified 2 years, 1 month ago by speleo.

That’s a super fast response. Wasn’t expecting that!

Database
https://www.dropbox.com/s/u5rgvntki2ku83o/test_historical_membership.sql?dl=0

The chart I’m looking to create shows the number of members of a club for each year. There are several membership types which should be stacked for each year.

SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 1 GROUP BY club_year ;
SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 2 GROUP BY club_year ;
SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 3 GROUP BY club_year ;
SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 4 GROUP BY club_year ;
SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 6 GROUP BY club_year ;
SELECT club_year, COUNT(*) AS count FROM  test_historical_membership WHERE type = 7 GROUP BY club_year

Label for X axis: Club Year
SQL field name of X axis: club_year

Label for Y axis: 1;2;3;4;6;7
SQL field name of Y axis: count

https://www.dropbox.com/s/sf93he04y2dij8g/chart_1.JPG?dl=0
https://www.dropbox.com/s/2czrx77bn9g9dze/chart_2.JPG?dl=0
https://www.dropbox.com/s/ri1rmcp2oe0mp38/chart_3.JPG?dl=0

As you see from this chart all the data sets start from 0,0 rather than being linked to the Y axis. I tried the various options in

Force start X axes at 0 Force start X axes at 0
Show only round numbers in Y axis ticks Disable “stackedness” for datasets

but these settings made no difference.

You’ll also notice that I’ve not included (membership_type = 5)
SELECT club_year, COUNT(*) AS count FROM test_historical_membership WHERE type = 5 GROUP BY club_year ;

As this returns 0 results which stops the whole graph from showing. I can work around this so not an issue, just an info for you.

Many many thanks for your help with this!!!

Thank you Kento. That explains things nicely. I’m in the process of migrating the site from Joomla and the “public” group was imported from there. Makes sense now.