Lollipops

Example Lollipop file with a scale of 200.

Lollipops are used to visualize data at geo-tagged locations through a circular chart divided into variably sized colored sectors, representing the proportion of the represented data. The format can be customized with as many levels as you want and can be used to visualize information and link datasets.

Purpose

Lollipops visualize data at specific locations using circular charts. Each sector represents a proportion of the data. The format is flexible and can be customized for different datasets.

File structure and rules

Lollipop data must be written in a CSV file with the following columns:

Header	Description
Parent	ID of another entry (empty means no parent)
Identifier	Unique ID for this entry
Name	Name of this entry
Value	Numerical value (KPI value)
Unit	Unit for the value
Description	Description for the entry
Latitude	Latitudinal angle in degrees
Longitude	Longitudinal angle in degrees
Color	RGB color (double quotes, no spaces)
Scale	Multiplier for visuals
SourceFile	Category + file name (e.g. “Lollipop\Aalesund\KPI.csv”)
Dataname	Header or dataname for the referred data

Rules:

• The .csv file must follow the format above.

• All fields separated by comma (,)

• Double quotes around Color

• Color definition should not have spaces

• No additional end-of-lines at the end of the document or between the header and data

• No special characters (e.g. Æ, Ø, Å)

• No commas besides in color definition

• Each Lollipop requires one child

Example of a Lollipop CSV file in Excel format

Format all columns as text. Open any saved or exported CSV files in a text editor to verify the format.

Parent	Identifier	Name	Value	Unit	Description	Latitude	Longitude	Color	Scale	SourceFile	Dataname
	Aalesund	Aalesund				62.47	6.1366	“204,255,255”
Aalesund	SC	Society			KPI-Domain			“255,228,196”
SC	SC_ED	Education			KPI-Category			“188,143,143”
SC_ED	SC_ED_1C	Student ICT Access			KPI			“255,182,193”
SC_ED	SC_ED_2C	School Enrollment			KPI			“255,99,71”
SC_ED	SC_ED_3C	Higher Education Degrees			KPI			“233,150,122”
SC_ED	SC_ED_4C	Adult Literacy			KPI			“160,82,45”
Aalesund	EN	Environment			KPI-Domain			“227,238,203”
EN	EN_E	Energy			KPI-Category			“177,188,143”
EN_E	EN_E_1C	Renewable Energy Consumption			KPI			“240,230,140”
EN_E	EN_E_2C	Electricity Consumption			KPI			“143,188,177”
EN_E	EN_E_3C	Residential Thermal Energy Consumption			KPI			“189,183,107”
EN_E	EN_E_4C	Public Building Energy Consumption			KPI			“85,107,47”

Example of a Lollipop CSV file in text format

Parent,Identifier,Name,Value,Unit,Description,Latitude,Longitude,Color,Sourcefile,Dataname,Scale
Aalesund,Aalesund,Aalesund,,,,62.47,6.1366,"204,255,255",,,
Aalesund,SC,Society,,,,KPI-Domain,,,"255,228,196",,,
SC,SC_ED,Education,,,,KPI-Category,,,"188,143,143",,,
SC_ED,SC_ED_1C,Student ICT Access,,,,KPI,,,"255,182,193",,,
SC_ED,SC_ED_2C,School Enrollment,,,,KPI,,,"255,99,71",,,
SC_ED,SC_ED_3C,Higher Education Degrees,,,,KPI,,,"233,150,122",,,
SC_ED,SC_ED_4C,Adult Literacy,,,,KPI,,,"160,82,45",,,
Aalesund,EN,Environment,,,,KPI-Domain,,,"227,238,203",,,
EN,EN_E,Energy,,,,KPI-Category,,,"177,188,143",,,
EN_E,EN_E_1C,Renewable Energy Consumption,,,,KPI,,,"240,230,140",,,
EN_E,EN_E_2C,Electricity Consumption,,,,KPI,,,"143,188,177",,,
EN_E,EN_E_3C,Residential Thermal Energy Consumption,,,,KPI,,,"189,183,107",,,
EN_E,EN_E_4C,Public Building Energy Consumption,,,,KPI,,,"85,107,47",,,

Download CSV

Visualizing Lollipops in Sandbox

Uploading the CSV file

Upload the Lollipop CSV file by using the Datasets Library. Select Lollipop as dataset type from the category drop-down menu.

Loading the Lollipop

After uploading, load the Lollipop as described in the Local Data section. Press the Press the Reload Data button.

Lollipop visibility

Lollipops are visible by default after loading from Local Data. Toggle visibility as described in the Data View section. Lollipops are not affected by the Timeline.