Une erreur est survenue. Détails Cacher
Vos pages ne sont pas sauvegardées. Rétablir Annuler

COMESA Brief Overview

ABOUT COMESA Statistics

The COMESA Treaty provides the policy context for the development of statistics in the COMESA region. The treaty envisages a four-pronged strategy for the development of statistics namely:

  • A Common Market Information System - This was to be established for purposes of reviewing the functioning and development of the Common Market. Issues to be handled included data flows to the Secretariat, improvement of data collection by Member States, analysis of statistical information and timely dissemination. 
  • Cooperation in Statistical Development - This recognizes the importance of harmonized statistics at the regional and international level, exchange of skills among Member States, cooperation in methodological issues, data dissemination policies and the adoption of the Addis Ababa Plan of Action for Statistical Development in Africa. 
  • Comprehensive Information System - This was to look at the development of a trade information network that reduces information asymmetries on trade opportunities in the region.  
  • Depository Library - In addition to documents and printed material, databases are envisaged as important for the development of the Comprehensive Information System. 

The COMESA Statistics Strategy (2014-2017) specifically provides guidance for implementation of statistical development in COMESA. 

 

The global objectives of the COMESA statistics Strategy are:

 

  1. To ensure that statistics in the region are produced using harmonized frameworks and/or international standards in order to ensure comparability.
  2. To enhance the quality, availability and comprehensiveness of statistics in the region.
  3. To ensure a wide dissemination of statistical outputs for use by policy makers and COMESA member States in their review and monitoring of the Common Market.

 

At the policy level the implementation of the Strategy is coordinated by the COMESA Committee on Statistical Matters, which reports to the COMESA Council of Ministers.  Statistical Regulations define the work flow from statistical compilation and harmonization to data transmission and dissemination. 

Merchandise trade statistics have been compiled at the Secretariat for the longest period. These statistics are derived in most cases from Member Country EUROTRACE databases. Statistics on International Trade in Services are derived from the balance of payments current account data from Central Banks of Member Countries.

The harmonized consumer price index is compiled by COMESA Member countries from their consumer price index monthly compilation. This index compiled and disseminated monthly and was launched in 2011.

COMESA Member Countries have participated and will continue participating in different rounds of the world wide project on the International Comparison Program (ICP).

This is the most comprehensive endeavor to measure purchasing power parities (PPPs) across world economies.

Infrastructure statistics include energy, transport and information technology and communication indicators. COMESA was part of the African Infrastructure Knowledge Program and together with the African development bank has been involved in developing this cluster in Member countries.

Foreign direct investment statistics and statistics on activities of transnational corporations have been developed as part of a joint UNCTAD-COMESA effort to develop capacity in Member States to compile these statistics. So far as number of COMESA countries collect FDI statistics based on enterprise surveys.

Industrial Statistics are compiled from Member States. Recognizing the different stages of implementation of the recommendations in the 2008 international Recommendations on Industrial Statistics (IRIS 2008) and the International Recommendations for the Index of Industrial Production (2010 IRIIP), COMESA together with UNIDO are involved in building capacity in Member states.

For Environment Statistics, COMESA is building capacity in member states on the implementation of the Framework for Development of Industrial Statistics (FDES). The United Nations Statistics Division is a key partner in this endeavor.

COMESA’s role on Agriculture Statistics falls under the ambit of the African continent’s lead implementers of the Global Strategy for Agriculture and Rural Statistics.

All these statistics and related statistical products are disseminated on the COMSTAT data portal.

Underpinning COMESA’s statistical development strategy is the creation synergies with other regional and sub-regional organizations as well as international organizations to ensure rationalization and efficiency in the development of statistics in Member Countries. Among the critical inputs the global statistical community provides for COMESA’s regional program is the drafting of global statistical standards.

 

 

GLOSSARY

 

  • Dashboard/Report/Visualization – a graphical summary of various pieces of important information by using a combination of gadgets, typically used to give an overview of a business.
  • Data – facts and statistics collected together for reference or analysis.
  • Data Browser – a page, which enables user to view and access the Portal’s datasets.
  • Data Source – an original data source, that is, one in which the data are collected firsthand by the researcher for a specific research purpose or project.
  • Dataset – structurally and logically separate set of data, presented in our application as a separate object with own ID. Each dataset may contain several indices (Index: time series in dataset. Combination of single selection in each dataset dimension).
  • Gadget – an instrument for data visualization.
  • Gadget Bin – a place on the Portal, where users can keep private copies of some pages are stored (accessible by link: http://comstat.comesa.int/user/fav ).
  • Gallery – data–driven content selected by the Portal team and designed to overview subjects and sectors of interest
  • Layout – a way in which the parts of dashboard are arranged or laid out.
  • Parametrization (parametrize page) – when you need its gadgets to depend on a parameter which user can change.
  • Pinned = Favorite.
  • Series (Time Series) – a series of values of a quantity obtained at successive times, usually with equal intervals between them (annually, quarterly, monthly, weekly, and daily).
  • Topic – in the context of data browser: datasets separation into topics that are defined by the Portal Team.

USER INTERFACE

Home 

 

 

 

 

 

Open Data

 

This page provides access to publicly available international databases:

 

 

Dashboards

 

Data-driven content selected by the Portal team and designed to overview subjects and sectors of interest. You may browse through content categories/topics, selecting any page to view and interact with visualizations.

 

 

Export page

Export visualizations

 

Add to Bookmarks

 

NOTE: Your gadget bin appears in the top banner once you save items to it. For more information on using your gadget bin, please refer to Creating a Dashboard.

 

Save Copy

 

 

Tools

 

Resource Center

 

User Profile

–°lick on your name on the top right corner to open your profile. Here user can review information on dataset’s updates and resources.

 

 

 

Notifications

 

 

Dataset updates

User can subscribe on dataset updates.

Step by step guide:

  1. Select dataset
  2. Open dataset in Dataset Viewer mode
  3. Click + (Follow) button

 

 

 

You’re following all dataset related updates.

 

 

 The same way you are able to unsubscribe. Just click the ‘Unfollow’ button. Go to the user profile to manage notification settings.

 

 

Change update frequency (never, immediately, once a day, once a week, once a month).

 

User will receive e-mails with updates and information with updates in profile

Example of notifications in profile:

 

 

E-mail example:

 

 

Timeseries updates

Receive notification about fluctuations in data that matter to you. Subscribe for data alerts wherever you see the alert symbol.

Step by step guide:

  1. Select dataset
  2. Open dataset in Dataset Viewer mode
  3. Select data you need
  4. Click ‘Bell’ button
  5. Set conditions. There are two types of conditions:
    1. Change of indicator’s value is less that X Units
    2. Change of indicator’s value is more that X Units

 

 

User successfully subscribed on updates. Also user is able to change notification settings.

 

 

 

Resources

 

 On this tap user is able to review recently viewed datasets, pages, apps, documents. Manage content.

 

 

My Bookmarks

Here user finds all items you added to your gadget bin.

 

 

Data Search

 

Search tool is accessible at home page or at: http://comstat.comesa.int/search. Type key word of request, for example, enter ‘Nigeria CPI’ in the search field. Firstly, most relevant results will be shown:

 

 

To view more results scroll down and click more time series/visualizations/ datasets. Here you can: add to favorites selected time series, go to dataset, go back to all results, add filters to reduce number of time series and select country/topic/data source.

 

TILES

 

Foreign trade – contains list of datasets related to Foreign Trade Topic

  • Infrastructure – contains list of datasets related to Infrastructure Topic
  • Economy – contains list of datasets related to Economy Topic
  • Agriculture- contains list of datasets related to Agriculture Topic
  • SSCBT
  • SSCBT datasets, compile data from SSCBT sources nominated by COMESA
  • a comprehensive set of visualizations to describe the project progress, member rankings and other SSCBT related information.
  • Monitoring COMESA progress –
    • Progress Towards COMESA MEC Targets
    • Macro-Economic Convergence Achievements
  • Member Country Profile- Data Atlas by key indicators selected for COMESA,
  • News
  • FAS - – contains list of datasets related to Foreign Affiliates Statistics Topic

 

MANAGER TOOLS

 

Main manager tools are accessible on the top of each page:

  • Create a dashboard
  • Upload data
  • Content Editor
  • Admin

 

 

 

Create Dashboard

 

Standard report/dashboard (by using “Bookmarks”)

 

“Bookmark” is a virtual space where you as a registered user may save visualizations to for reuse in other dashboards. To save and use visualizations with the gadget bin:

  1. Locate a visualization of interest:
  2. Click Create Dashboard button on the top of the page.
  3. Choose your preferred layout and click Create.
  4. If you have more than one gadget in your bin, you will be able to scroll through each to select the gadget you want.
  5. You may now choose from the top right dropdown on the visual to Edit the visual.
  6. You can make modifications to the content (‘Dimension Filter’) and the appearance. These functions are described in the next section.

Customized reports/dashboard

 

To create a custom dashboard:

  1. Click Create Dashboard button.
  2. Choose your preferred layout and click Create.
  3. A new page opens with the selected layout.

    NOTE: User can change dashboard’s layout after page creation.

    Click to Split at the bottom of the gadget and choose the way you want to split placeholder.

    Click OK.

 

 

Under each content area, you can see various options to add content.

 

 

You can also split each content area to make additional visualization spaces or delete this area:

 

 

Resize a dashboard

NOTE: To resize a placeholder, simply start dragging its boarders. Note that vertical size of the page might be as big as you wish, but the width is limited to 940 pixels.

4. Select any of the visualization options to begin building your dashboard.

5.Select dataset (for some gadgets there is an ability to add more than one dataset. Click the Dataset Selection tab again and click Browse Dataset to locate):

6. After you select the dataset, the page redirects to Dimension Filter Here you need to select data in each dimension.

 

Customize

User can customize visualizations. It means that there is an ability to manage axes.

Note: You can change default axes position in "Appearance" tab too, click to "Swap axes".

 

Rows and Columns in Tables

You can change the positions of dimensions for table. To do that you need to click customize and for each dimension select column/rows/filter.

 

Calculation

Start editing a gadget then edit or create a new calculated element (click “add calculation”). Click a field along the bottom of the control panel. To add an indicator to a field, click the name of a desired indicator from the list above.

 

NOTE: To add a constant value to the field, click the Const button, and then type the desired value in the field. By default, the value will be set to 0.00.

 

 

 

After that you need to choose indicators for calculation, add formula and change name of new indicator:

 

 

Add an operator to the formula:

To add an operator to the formula, click a field at the bottom of the control panel. You may select an empty field or a field that already contains a term. 

Click an operator button. For example:

  • Click + for addition.
  • Click – for subtraction.
  • Click * for multiplication.
  • Click / for division.

Specify a Quantity

To specify a quantity, click a field at the bottom of the control panel. You may select an empty field or a field that already contains a term. Then click the ( ) button. The site encloses the selected field in parentheses.

To perform an operation on the quantity, drag the desired operator button from the control panel and drop it on the opening or closing parenthesis.

Delete a term from the formula

To delete a term from the formula, select the term, and click DELETE.

 

NOTE: If you see a data of your interest in the Dataset Browser and you want to create a page on top of it, no needs to start from scratch and replicate all the same steps again just to query the same data.

 

 

 

7.  Click the Appearance.

 


 

Description of common options:

 

 

 

General

 

 

Theme: Select the color scheme for your graph. As you select the theme, the color/background color changes in the preview.

 

Chart Type: Select alternative graphs. The tool lists the graphing options based on the applicability to the type of data selected. Some visualization options will not be depending on your data type.

 

Labels: Select this tab to display the numeric values in the graphs.

 

Precision: Adjust the number of decimal places shown: 0 indicates no decimal values after the numeric value; 1 indicates .0 after the numeric value; 2 indicates .00 after the number value; etc.

 

 

Highlight: You can highlight some time period for line chart.

 

 

Sort option: You can apply options to your visualization based on the data.

 

Footnote: Add a custom footnote for your visualization.  The default setting is blank (none). Or, select Auto and the tool will insert a hyperlink to the dataset source.

 

 

Plot area

 

 

Background type/color: Select the background type and color. As you make selections, the preview pane automatically adjusts.

Legend: Set the caption for your visualization, based on options.

Gridlines: Display or not horizontal and vertical gridlines.

Text note: Add fluctuated panel with your custom text.

 

Series

 

 

 

  1. Select a chart series from the drop-down list.
  2. Change name of an indicator and click ‘Set’ to apply it. This often enables the user to apply a more meaningful title based on the purpose of the visual.
  3. Change the background color for the selected indicator.

In this block user may change following parameters:

  • Line type
  • Line width
  • Add markers
  • Add labels
  • Determine axis for particular series

8. After you select your requirements, click Save.

9. Name and Save your dashboard before building additional content.

10. Edit Description:

 

11. In addition, before completing your dashboard, determine the following:

Moreover, each item within your personal dashboard will have several functions you may exclusively perform (unless you have granted access to other users):

 

 

Note: Options will differ according to the gadget / visualization type.

 

Parametrization

When you want to create, for example, a country specific report and extend it to other countries so user can select one to show.

When you need its gadgets to depend on a parameter which user can change, it is called "parametrize a page".  When you parameterize a page, you make the element selection of one of its dimensions a variable rather than a fixed value. The users to your page can change the selection in this dimension and see different results. For example, if you parameterize the country dimension, your users may change the default country selection to any other country in the dataset.

  1. To do that you need to click the Parameterizelink in the toolbar. The site opens the Choose Parameter dialog box:
  2. Select a dimension which will be variable by picking a corresponding element from the Dimension drop-down list.
  3. Specify a name for the parameter.
  4. Choose Display all members option if you want the parameter to show all available elements; choose Restrict to selected members option to define a list of elements to be available to users.
  5. Click Save to apply changes.

    Once you save the parameterized page, the site adds a drop-down menu to the right side of the interface. Select a new element for the parameterized dimension by choosing a value from this drop-down menu. All the gadgets on the page that share the same definition as the parameterized dimension automatically update themselves to show the appropriate data for the new element selection.

 

DOWNLOADING DATA

 

You may download data from a dataset following these steps:

  1. Select the dataset.
  2. Select the indicator.
  3. After you click Download, you will be redirected to the Download status page, displaying the status of your data download.
  4. Open your mail box to view the download email sent by the system.

 

 

UPLOADING DATA

 

The Uploading Data page is accessible at the link (https://comstat.comesa.int/user/lightupload) or by clicking button ‘Upload data’ on the top of each portal’s page. The Portal require visitors to register to access the portal’s uploading data page. If you request and receive permission from your Portal Team, you will also be permitted to upload your own datasets and build dashboards using the datasets available in the Portal.

 

 

The following section will walk you through Uploading Data page section of the data portal that is available to a registered user, including special permissions for users with contributor-level access to datasets.

 

Using Personal Datasets in the Portal

 

As a registered user, you may upload datasets to the portal to build visualizations. You may choose to keep your datasets private and share with only select users. This section will provide an overview of how to upload and maintain personal datasets as well as offer guidance on how to format datasets with unique features, such as more than one language.

Add Personal Datasets

This section is providing guidance on preparation and upload of new datasets as well as removal of the same.

Prepare your dataset

Uploading data to the portal begins with preparing your dataset. Following are some definitions and guidelines to consider, including

  • Dataset type
  • Indicator notes
  • Dataset language
  • Local and foreign currencies
  • Multiple data editions

Dataset type. Two primary types of datasets are used and are differentiated based on the complexity of the data structure they capture: Flat and Standard (KNOX).


Flat dataset. A flat dataset is defined by a single row of column labels with rows of content beneath that contain all of the data in the dataset. No other Excel worksheets are required to list other dimensions. This type of dataset may be viewed in a table format and, as such, that gadget option is available among the visualization tools in a dataset browser window.

 

 

 


Occasionally you may want to build a simple dataset consisting of only one column of data. In these instances, you will likely have a total of three or four columns to provide: indicator name, unit of measure, data, and possibly a column listing each indicator name in English (or another language). Like a flat file, this file requires only one worksheet, as shown in the example below. Note that Unit is not translatable.

 

 

Regular (KNOX) dataset. In contrast, a regular dataset uses multiple worksheets to establish the hierarchical structure of the dataset. At a minimum, each KNOX dataset uses three types of worksheets.

Worksheet 1 – Dataset. The Dataset worksheet contains the basic metadata and references to other worksheets that provide the dataset’s structure. Metadata includes:

  • dataset name; optional fields: provider (source), the original URL, publishing frequency and date, next release date, and accessed on date.
  • dimensions records the name of the worksheet with the data variable names and hierarchy.
  • data refers to the name of the worksheet(s) containing the data.

 

 

 

Worksheet 2 – Indicator. A KNOX file will have as many Indicator-type worksheets as there are dimensions listed in the Dimensions field of the Dataset worksheet. The name for each Indicator-type worksheet must match the name used in the Dimensions field. Indicator-type worksheets establish the dimensions of the dataset and the hierarchy within each dimension.
The first four columns—Code, Name, Order, Parent—are core to the dataset structure and must appear. Note that the Parent column provides the structure for all indicators with a dimension.

 

 

 

Worksheet 3 – Data. The Data worksheet can only be finalized once the Indicator worksheet is developed, because Data uses the codes from Indicator to link the data to the names in the Indicator sheet.

 

 

 

We recommend splitting datasets exceeding hundreds of columns into multiple data worksheets.

In addition, datasets that offer multiple periodicities for the data—such as monthly and annual—should also use multiple Data worksheets to separate the data and make it simpler to update.

  • Enter the worksheet names, separated by a semicolon, in the worksheet Dataset > Data No spaces may be used between semicolons and worksheet names or within worksheet names. Use DataD, not Data D, for example.
  • You must use the following time formats when entering the data itself into a Frequency column in the appropriate Data worksheet.

 

Indicator notes. Sometimes a specific indicator has a definition, methodology, or other associated information that you will want to specify for users to view within the dataset browser. This is the purpose for the blue icons within a dataset next to an indicator name. The simplest method to add notes is to use a ‘Notes’ column in a dimension-specific worksheet of your data upload template.

 

 

Dataset language. Datasets can include multiple languages.  Following is an overview the general process you will follow to add a language to your dataset depending on the type of dataset (standard KNOX/ flat).

  • KNOX dataset. Within the Indicator worksheet, add a column for each additional language after the core columns. Each column should be labeled with the language name and contain the translation for each item within the dimensions that appears in the original language. In the example below, the original dataset language is English, the second language is French.

  • Flat dataset. As with the KNOX dataset, add a column to the worksheet with a translation for each indicator Name. When you upload the dataset, set Type as “text” and Status as “dimension” for the fields you want translated. You will also select the name of the dimension you want translated in the “Grouped to” section. Details on the upload process, including Type and Status selection, are available in the next section.

 

 

Local and foreign currencies. Datasets can include multiple price types for indicators. To add a second price type you will need to create a new dimension—Price Type—which involves several steps, as follow:

  1. On the Dataset worksheet, Dimensions row, add a semicolon (;) and Price type (no space). Insert a new worksheet Price type.
  2. You will use at least three columns: Order to determine the sequence in the dataset, Name in the dataset’s original language, and Code for the price type’s abbreviation. You may add a fourth column for a second language in the dataset. Each price type appears in its own row.
  3. In the worksheet Data, you will copy and repeat all columns and rows, changing the Price type abbreviation, Price TypeName, Unit, and numerical values for each year. The Indicator value remains the same.
  4. When you upload your dataset, you will see Price Type as a dimension in your dataset. It uses the Price TypeName from your dataset to provide you with the option of which Price type to view your indicators in.

    NOTE: You can follow the same steps to add any indicators-like dimensions into your dataset.

Upload dataset to portal

Once your dataset is prepared, uploading the dataset to the portal begins with the launch of the data upload wizard from user menu at top right. Each type of dataset—standard KNOX or flat—follows a slightly different upload process and will be address separately in this section.

Standard KNOX Dataset

  1. Select your data file. You may drag a file from a local folder and drop it into the application; browse and select the file from a local drive; or paste data from the clipboard. The application support data in XLS, CSV, and TSV formats.
  2. Specify the metadata, including dataset name, description, URL (if applicable). Use the description field to enter information about the dataset, how it was collected, responsible offices, or any other information that might be useful to a general user.

 

Follow these guidelines to set accurate dates:

  • Publication date refers to the date when the data was officially published by the original source. It must be a date in the past.
  • Next release date refers to the next official publication date.

Accessed on date refers to when the dataset was retrieved. The Accessed on date must be after the official publication date.

3. When you have finished entering the metadata, select Submit to complete the upload. An Update status report will pop up during the upload process followed by an Upload report.

 

NOTE: During data upload and update process, the email account attached to a user’s registration on the portal will receive automatic notifications to update the user on the status. Successful uploads will result in an email that includes a hyperlink to the new dataset. Failed uploads result in an email that includes details about the reason(s) for the failure.

 

Flat dataset

Alternatively, we recommend using the Custom upload settings for flat datasets so that you can verify all meta data during the upload process.

  1. Select Custom upload settings.
  2. On the next screen, choose Select file to upload and locate your file.
  3. The upload wizard will provide a Verification has finished notice and return an interactive table that lists all aspects of your dataset. Review the Type and Status settings to ensure the tool has accurately specified each column from your dataset. Some general guidelines on Type and Status assignments:
    • This field previews what information is being processed in each row category. Pay attention to any field that has a mix of text and numbers. These fields must be assigned a Type of Text, not Measure.
    • The Status type Dimension will create that parameter as a dropdown menu option within the dataset for selection of data categories to visualize in the dataset browser. Only data rows in your spreadsheet that are complete—no data gaps—may be set as a Dimension.
    • The Status type Detail is typically used for information that would work with the grid visualization tool.
  4.  

  5. Once you have verified the Type and Status for all rows of your dataset, select Submit to complete the upload. An Update status report will pop up during the upload process followed by an Upload report in which a live link to your new dataset is included.

 

In those instances that you wish upload a simple flat dataset with only a single data stream—perhaps one year of data for several indicators—you will follow an equally simple upload process:

  1. Browse your local drive to select your data file.
  2. Select Open in your file section window.
  3. The simple file structure allows you to immediately view it in the data browser. At this point you may choose to rename the dataset, adjust privacy settings, assign tags, and submit it for verification. These processes are described in the next sections of this guide.

Remove a personal dataset

 

To remove your personal dataset from the portal:

  1. Within the dataset browser, open the More Actions dropdown menu, and select Edit details.
  2. Scroll down the page to select Delete Dataset.

 


 

Categorize and Tag Datasets

Intuitive access to datasets and dashboards is a product of sorting and classification. The portal has embedded search options, or users may also go to the statistics to locate data.

Tagging datasets

 You can assign tags to your dataset during the upload process or anytime thereafter, including after verification of the dataset. Be advised that the portal managers may add, remove, or modify tags on any datasets added to the open data portal.

To add or modify tags for personal datasets—or those shared with you by another user and including edit or owner permissions—follow these steps:

  1. Open your dataset.
  2. Click Edit under the dataset name. The keyword field opens.

3. Type the keywords that you want to add it to your data and click Save.

 

 

After you click Save, these keywords can be used to browse datasets under Topics. When you click Topics, from the Dataset browser, all the keywords that are tagged with datasets in the portal’s Statistics appear. Your catalog of topics will differ from the public list unless you verify your dataset list with the portal managers and your dataset (and its tags) are made public. See: Verification of datasets and Assign dataset access levels.

 

Additional Specialized Dataset Options

 

As a dataset owner, you will be able to manage several dataset options ranging from viewing and sharing options, tags, methodology notes, and language selection. This section describes each of these specialized processes.

 

Sharing a dataset

A dataset may be uploaded for private use and viewing (default setting), public access in the Statistics (after verification), or shared to specific users.

In addition, through Sharing options, users may be assigned unique access rights that affect usage and editing/modification rights. A dataset owner and a portal manager will have equal access to edit/modify a dataset, however, the owner’s name will be displayed at the bottom of the dataset under ‘Uploaded by’.

Submitting dataset for verification

 

After you upload your dataset, the dataset will be in ‘Not Verified’ status. The assigned administrator will need verify the dataset before it can be published on the portal.

To submit your data for verification:

  1. Select the dataset from the Statistics or My Account page that you want to send for verification.
  2. From More Actions menu, click Submit for verification. After you click Submit for verification, the following page opens.
  3. At a minimum, you must enter the dataset name, source, reference URL, and publication date to submit the dataset. The other fields are optional but advisable to include, if possible.
    1. After you enter all the details, click Submit for Verification, and confirm you want to send the dataset.
    2. The dataset will now be in Verification Pending You will receive an email in your registered email confirming that your dataset submission is pending verification.
    3. The assigned administrator will review the data and approve or reject the dataset.

    If approved, the status will change to ‘Verified’ and you will receive a verification-success email.

    If rejected, the status will change to ‘Not verified’ and you will receive a verification-rejected email detailing the reasons the dataset was rejected. You may correct the errors and resubmit the dataset using the same upload and verification process.

    NOTE: After updating a dataset or editing its metadata fields, such as “Source,” the status will return to unverified by default. Users must resubmit updated datasets for verification. All public datasets, regardless of whether verified, are publicly viewable.

     

    Setting the language for indicator names

     

    Some datasets include indicator names in more than one language. One language is the ‘base language’ and will be used for all indicator names, regardless of the user interface language selected, unless another language is chosen.

    To change the language indicators appear in, follow these steps:

    1. Select the Dataset from the statistics that you want to modify.
    2. From More Actions menu, click Edit metadata.
    3. Scroll down the page until you see the blue hyperlinked Indicator (or any other dimension names) text. Select Indicator.
    4. The screen will refresh. Scroll down to the Fields This example dataset included a translation for each indicator from English to French. Select French (name of column where are located French names of indicators) from the Name column.
    5. A pop up window appears. Change Locale to French and Base Field to Name.
    6. Select OK and Save your changes. The dataset will now appear in the browser with Arabic indicator names in French version.

    Update Personal Datasets

     

    As a general user, you can only update private datasets or those datasets that other users have granted you editorial permissions. To update your datasets:

    1. Prepare your update file.

    The update file for a standard KNOX dataset needs only to include the data worksheets that are being updated. In our running example, it might look like the following image.

     

    The update for a flat file requires only that you change the field values within the worksheet.

    For either file type, if your update requires the addition of new indicators, you will need to follow the steps to Add Datasets.

     

    1. Open the dataset in the Dataset Viewer.
    2. Open the More Actions drop down menu to select Upload data.
    3. Select the updated file from the local drive and click Submit.

    If you are updating a flat file, the update tool will now ask you to select whether you want to ‘overwrite’ or ‘append.’

    • Append means you are adding new data to the data that already exists in the dataset. If your file replicates data already existing in the dataset and you choose Append, the upload tool would add a duplicate row of data into the dataset.
    • Overwrite means you are deleting all the old data from the dataset and overwriting it with data from the new update file.

     

    The application returns a verification that the upload has finished and provides a summary.

    1. Select Submit The application will upload the data and return a confirmation report. Note that the report provides a count of new data points added in by the update.

    In addition, in the Update Notes field a manager could include information about the data, methodology, or other pertaining to the update. Users must resubmit the datasets for verification after each update if the dataset is public.

    1. Select the hyperlinked dataset from the Upload report.
    2. At this point, we recommend you Submit for verification.

     

    WARNING! If you do not verify the updated version of the dataset before linking it to a previous, verified version, neither version will be viewable in the Statistics.

     

    Items 8-13 will explain the process for a dataset update that requires structural changes.

    Note: You can not to change structure of existing dataset (add in the dataset new dimensions).

     

    In this scenario, you must upload the new dataset, as previously explained, and set up it as a replacement dataset for the old version as follows:

    1. Select the star on your new dataset to pin it to your personal favorites. This step is not required, but it will make it easier to locate in the Statistics for the steps that follow.
    2. Return to the dataset browser and the previous version of the updated dataset. Go to More Actions > Edit Metadata.

    3. Scroll down to Replacement dataset and select None.
    4. Select the dataset pinned in step 8 and click OK.
    5. The replacement dataset field now shows the title of the replacement dataset. Select Save.
    The older version of the dataset now shows a yellow warning banner in the data browser—as well as in any visualization/dashboard built on the dataset—to alert users

Notre déclaration de confidentialité et notre politique en matière de cookies

Notre site Web utilise des cookies afin de faciliter votre expérience en ligne. Ils ont été enregistrés sur votre ordinateur lorsque vous avez lancé ce site Web. Vous pouvez modifier vos paramètres personnels relatifs aux cookies via les paramètres de votre navigateur Internet.

Politique de la protection de la vie privée