Topic: Geographical statistics, analyses and charts  (Read 43465 times)

Is it possible in ConfTool to obtain statistics about the geographical spread of the participants and the papers accepted?

You can get a first overview of where participants, authors and other user groups are from, when you go to the list of all users:
Overview => User and Participant Management => List of All Users
When you open the filter for "Country", you can see how many users come from each represented country as a number behind the country name.
When you use the filters above the "Country" filter (for instance "Only Users With Status"), the list of countries will show the number of users from each country related to the selected filter condition (see image 1).

You can furthermore easily export participants, authors and other user groups by country.

Please go to:
Overview => Data Import and Export => Export Data
Please first activate the expert settings by scrolling to the bottom of the page and clicking on "Expert Settings Disabled" or the cogwheel icon.

Then click the radio button for the option "Export Users by Country" (see image 2). This will create an Excel sheet that lists the location data of each ConfTool user. You can further narrow down the group of users when you go to the option "Only Users With Status" and choose a setting from the drop-down list. This export was prepared for mapping tools like OpenHeatMap, Google My Maps, ZeeMaps, Community Walk, MapBox, MapMe.

If you want to export only the countries and the number of users per country as a statistical overview, then click the corresponding checkbox. Again, use the additional option "Only Users With Status" to limit the export to a certain group of users (see image 2).

However, when you want to obtain for example an overview of the geographical spread of accepted papers, use the export function of ConfTool and then continue to analyze the data in a suitable office application, as there is no direct statistical evaluation for submissions and the country of their authors.

Please go to:
Overview => Data Import and Export => Export Data
... to export users, authors, participants or papers.

You can for instance open the file in Microsoft Excel (or OpenOffice Calc) and then analyze the data according to country or region. You can also use Excel to create charts and other graphical evaluations.

Example:
In order to count the number of items per country, insert two columns after "country". Now use the "Advanced Filter" of Excel (Data => Filter => Advanced Filter) to copy the records as unique entries to the next column. In the third column, use the command "=countif(from:to, value)"* to count the occurrences of each country in the original column and have the results displayed in the third column (see screenshot).
This data can now easily be used to create a chart.

* In der deutschen Excel-Version heißt das Kommando "=zählenwenn(von:bis; wert)" (mit einem Semikolon statt eines Kommas).

Another example: You want to check if a certain string can be found as substring in a column and then filter all rows that contain this substring.
Please create an extra column and use the "find" function of excel to create such a list:
=IF((ISERROR(FIND("Peggy",H2))),"Peggy","")
The new column will contain the string "Peggy" if the substring "Peggy" was found in field H2.
If it was not found, the new column will be empty.

In German Excel:
=WENN((ISTFEHLER(FINDEN("Peggy";H2)));"Peggy";"")