Events
Ideas
Product Updates

[Enquête annuelle de satisfaction 2024] - Votre avis compte !

13 days ago

Home
Search

Recently active topics

35 Topics

Recently active

Most views Most replies

omar-saip.syBeginner

asked in The world of data

Est-il possible de trier un graphique par l'axe des ordonnées après l'avoir ventilé ?

Bonjour, J’essaie actuellement de faire un diagramme en colonnes (barres verticales). Ce que je parviens à faire.Sauf qu’après avoir ventilé ma série, j’ai essayé de trier par les valeurs décroissantes de l’axe y.Mallheureusement, je n’y arrive pas et j’ai un tri par défaut (suivant l’axe des abssices).Dans l’éditeur de code, mon code ressemble à ça:<ods-chart single-y-axis="true" align-month="true"> <ods-chart-query context="ctx" field-x="x" maxpoints="50" series-breakdown="break" stacked="normal" sort=y”> <ods-chart-serie expression-y="y" chart-type="column" function-y="SUM" color="range-custom" scientific-di

16 hours ago

boris.djakovicBeginner

asked in The world of data

Issue with resetting the selection and reloading visualization in ods-select

I am experiencing an issue with resetting the selection in an ods-select element that is used in my visualization. <div class="grid"> <div class="shared-width-ods-selects"> <div ods-facet-results="reglist" ods-facet-results-facet-name="name" ods-facet-results-context="myctx0" ods-facet-results-sort="alphanum"> <ods-select ng-init="myctx0.parameters['refine.name'] = []" options="reglist" selected-values="myctx0.parameters['refine.name']" multiple="false" label-modifier="name" value-modifier="name" placeholder="Pflegeheime auswählen"> </ods-select> </div>

21 hours ago

yvonneBeginner

asked in Share data

Index column - adding via a Processor?

Hi - is there a way using a Processor to add an Index column to data? We can see an index of sorts on ODS but want to add an actual index column to be included in the data (within a dataset). We have been downloading/manipulating the source in Excel but would like to skip that step if possible.Auto-translation 🪄Bonjour - existe-t-il un moyen d'utiliser un processeur pour ajouter une colonne d'index aux données ? Nous pouvons voir une sorte d'index sur ODS, mais nous souhaitons ajouter une colonne d'index réelle à inclure dans les données (dans un ensemble de données). Nous avons téléchargé/manipulé la source dans Excel, mais nous aimerions ignorer cette étape si possible.

23 hours ago

azizaBeginner

asked in Organiser les données

count distinct graphique

BonjourMerci de votre retour concernant mon sujet"count distinct"! voici un exemple de mon jdd:Annee N° Produit2020 122020 122020 202020 202021 122021 132021 132022 122022 202023 122023 202023 202023 12Je dois avoir une courbe qui représente les données suivantes:Annee Nombre distinct de produits2020 22021 12022 22023 2Cordialement,Auto-translation 🪄HelloThank you for your feedback regarding my topic "count distinct"! Here is an example of my jdd:Year Product No.2020 122020 122020 202020 202021 122021 132021 132022 122022 202023 122023 202023 202023 12I must have a curve that represents the following data:Year Distinct number of products2020 22021 12022 22023 2Sincerely,

120

1 day ago

Tom SantosBeginner

asked in Share data

Connecting two graphs in one chart

Hello,We are currently trying to create a chart that contains information from two different datasets, one with the data collected until a certain date, and one with the forecast values starting the day after the last collection. Each of the individual information has stacked data and different colors.When we display the information in the chart, we have a gap of data between the last day collected and the forecast, which we would like to fill. As of right now, we have tried to:Set the first forecast date equal to the last collection date, which makes the day in common stack, since both of the individual data have stacked data; Place all the information together in one dataset, which makes it so we can’t change the colors between the collected and forecast data.Is there any solution to make a continuous graph with changing colors when moving from collected data to forecast? Here is an example of the code so far:<ods-chart align-month="true" single-y-axis="true"> <ods-chart-que

322

5 days ago

yvonneBeginner

asked in Gather data

Main ODS data portal - download catalog

I’m having troubles opening the Excel version of the catalog downloaded from the main ODS Data portal:https://data.opendatasoft.com/explore/ (bottom left hand corner) The Excel version does not open. The CSV version is messy Screenshot of CSV of catalog download Auto-translation 🪄J'ai des difficultés à ouvrir la version Excel du catalogue téléchargé à partir du portail principal de données ODS : https://data.opendatasoft.com/explore/ (coin inférieur gauche) La version Excel ne s'ouvre pas. La version CSV est désordonnée Capture d'écran du fichier CSV du téléchargement du catalogue

727

5 days ago

Gokul SureshBeginner

asked in The world of data

Postal code data public api not found

Hi,I'm using the following API from Opendatasoft to access postal code data:API Endpoint: https://data.opendatasoft.com/api/explore/v2.1/catalog/datasets/geonames-postal-code@public/recordsThis api is not available right now , When i trigger this api showing message like “The requested dataset geonames-postal-code does not exist.”. Please provide a reason for this Auto-translation 🪄Bonjour, j'utilise l'API suivante d'Opendatasoft pour accéder aux données de code postal :Point de terminaison de l'API : https://data.opendatasoft.com/api/explore/v2.1/catalog/datasets/geonames-postal-code@public/recordsCette API n'est pas disponible pour le moment. Lorsque je déclenche cette API, un message du type « Le jeu de données demandé geonames-postal-code n'existe pas ». Veuillez en indiquer la raison.

161

5 days ago

BhanupriyaBeginner

asked in Managing data portal

Wanted to add Button in information tab

Is there any option to add button or link a sheet in information tab for each dataset?Auto-translation 🪄Existe-t-il une option permettant d’ajouter un bouton ou de lier une feuille dans l’onglet d’informations pour chaque ensemble de données ?

140

6 days ago

orhan.saeediBeginner

asked in Share data

DCAT AP export of description as typescript

Dear ODS-community,When I export the dcat_ap_ch. I would like the descriptions to be in typescript (or something else being machine-readable). Is there a way to do that.https://data.bs.ch/api/v2/catalog/exports/dcat_ap_chThis is because, we always have to type out the URL’s for opendata.swiss and data.europe.eu to show them as clickable urls. Furthermore the “new lines” cause the problems that the urls are not always shown correctly.See:https://data.bs.ch/explore/dataset/100008/information/https://opendata.swiss/de/dataset/bade-trinkwasser-und-zierbrunnen-in-baselhttps://data.europa.eu/data/datasets/100008-kanton-basel-stadt~~1?locale=frAlso the other cantons (I checked) using ODS don’t seem to work. For Zurich it works:https://opendata.swiss/de/dataset/kinostandorte-zwischen-1907-und-2018Kind Regards,Orhan

513

6 days ago

boris.djakovicBeginner

asked in Organize data

Chart Displays Data Despite Empty Selection in ODS Filter

Dear ODS-Community,I am experiencing an issue with the configuration of an ODS filter where the chart displays data even though no selection has been made in the dropdown. I would like the filter to have no default selection and for the chart to display no data until a selection is made.Details of the Problem:The dropdown filter is configured to allow the selection of a care home. The filter is initialized with the value "All Care Homes," which causes data to be displayed in the chart even when the user has not made a specific selection. I want the filter to be empty by default and for the chart to show no data until something is selected.Current Code:Here is the relevant code that I am currently using: <div class="grid"> <div class="shared-width-ods-selects"> <div ods-facet-results="reglist" ods-facet-results-facet-name="name" ods-facet-results-context="myctx0"

333

6 days ago

ThomasKBeginner

asked in Managing data portal

Want to english texts in the export API

Hello,I want the texts in English (that are translated from Swedish into English and stored in the portal) when I download metadata from the export API. I want to check the quality of the translations and perhaps improve them using chatGPT,Anyone who have succeded to download the translated metadata with the export API? Please tell me how you did it. Auto-translation 🪄Bonjour, je souhaite obtenir les textes en anglais (qui sont traduits du suédois vers l'anglais et stockés dans le portail) lorsque je télécharge les métadonnées à partir de l'API d'exportation. Je souhaite vérifier la qualité des traductions et peut-être les améliorer à l'aide de chatGPT. Quelqu'un a-t-il réussi à télécharger les métadonnées traduites avec l'API d'exportation ? Veuillez me dire comment vous l'avez fait.

292

6 days ago

azizaBeginner

asked in Collecter les données

count distinct

BonjourDans un jeu de données, je dois faire un graphique ( ligne) qui représente le nombre de produits par année ( count distinct c’est à dire ne compter qu’une seule fois le produit dans une année). Pour info, les identifiants de produits ne sont pas uniques dans l’année.Auriez-vous une idée?Merci d’avance!Auto-translation 🪄HelloIn a dataset, I have to make a graph (line) that represents the number of products per year (count distinct, i.e. count the product only once in a year). For your information, product identifiers are not unique in the year. Do you have any idea? Thanks in advance!

891

7 days ago

Nicolas TerpolilliCommunity Manager

published in Gather data

Geographical referentials availability plan 2025News

A geographical referential is a dataset providing spatial information, such as the administrative divisions of a country or a territory.For a couple years now, we have invested in developing data pipelines in order to make those geographical referentials available in the product.They are available as simple datasets that you can use via federation for example. But they are also available in services: Processors (Geojoin and Retrieve Administrative Divisions) Studio base maps Providing those geographical referential is not an easy work. We rely on external sources. Even if they are official sources, they are sometimes not consistent in their release date. Also the API may change, the schema may change. It’s hard to keep up with the release even for us, so we know it’s even harder for you. Here is our plan in releasing geographical referential in 2025.We will try to keep it as up-to-date as possible. Though keep in mind that those dates are a best case scenario based on our experience fo

20413

7 days ago

boris.djakovicBeginner

asked in The world of data

Sorting Issue in Dropdown Filter: Lowercase Entries Appear Last Alphabetically

Hello dear community,I’m having an issue with sorting in the filter. I created a dropdown filter with the names of care homes. The problem is that the alphabetical order doesn’t prioritize uppercase and lowercase letters correctly. I have care homes named "dandelion" and "irides" which are lowercase and appear at the very end of the filter. Is there a way to work around this? <div class="shared-width-ods-selects"> <div ods-facet-results="reglist" ods-facet-results-facet-name="name" ods-facet-results-context="myctx0" ods-facet-results-sort="alphanum"> <ods-select ng-init="myctx0.parameters['refine.name'] = []" options="reglist" selected-values="myctx0.parameters['refine.name']" multiple="false" label-modifie

8 days ago

AgOREBeginner

détailler comment sont construits les indicateurs des statistiques d'usageOpen

La construction des indicateurs mériterait d’être détaillée et rendue disponible depuis le BO ou la documentation.Auto-translation 🪄The construction of the indicators would deserve to be detailed and made available from the BO or the documentation.

120

13 days ago

matthew.parryBeginner

asked in Share data

Linking one Date Range Slider to multiple datasets

I am creating a visualisation where I have two datasets plotted on a map, and I want to filter these by year with a slider. Currently I have two separate sliders, with each one filtering a different dataset. Is there a way to have one slider interact with multiple contexts? Current Code:<ods-dataset-context context="flexibilityprocurementareas,flexibilityexpressionsofinterestareas" flexibilityprocurementareas-dataset="flexibility-procurement-areas" flexibilityexpressionsofinterestareas-dataset="flexibility-expressions-of-interest-areas"> <div id="c1"> <ods-date-range-slider context="flexibilityprocurementareas" date-format="YYYY" initial-from="2023/01/01" initial-to="2029/01/01" precision="year" date-field="start_of_regulatory_year"

392

13 days ago

Freta HODS Team

posted in Nouvelles ressources

[Enquête annuelle de satisfaction 2024] - Votre avis compte !

🔎 L'enquête annuelle de satisfaction Opendatasoft a été lancée depuis quelques semaines. En cette fin d’année, il est important pour nous de savoir ce que vous pensez de la plateforme, des différentes évolutions, et surtout de recueillir vos précieuses suggestions pour continuer à grandir, améliorer notre produit ainsi que notre accompagnement. ⏳ Le questionnaire prend environ 3mn et sera accessible depuis le back-office jusqu'au 22 novembre. Vous ne voyez pas la fenêtre ?Si vous avez activé un adblocker sur votre navigateur, il est possible que l’enquête ne s’affiche pas. Si vous avez fermé l’enquête par inadvertance, elle s'affichera à nouveau dans quelques jours sur votre portail de façon automatique. Une fois que vous avez répondu, la fenêtre n'apparaîtra plus sur votre back-office. Merci pour votre précieux temps.Merci de faire partie de notre aventure !Auto-translation 🪄Participate in the 2024 annual satisfaction survey from the back office of your portal🔎 The annual Openda

650

13 days ago

David GuillaumeBeginner

asked in Share data

refine date parameter with actual date in ods-dataset-context widget

Hello,I have the same question as this one, but unfortunately, the answer doesn’t satisfy me (the proposed solution leads to another issue specific to my case). Is there a way to directly refine with the current date in the ods-dataset-widget? A solution in the spirit of the image below:thank you in advance.DavidAuto-translation 🪄Bonjour, j'ai la même question que celle-ci, mais malheureusement, la réponse ne me satisfait pas (la solution proposée amène à une autre problématique propre à mon cas). Existe-t-il un moyen d'affiner directement avec la date du jour dans le widget ods-dataset ? Une solution dans l'esprit de l'image ci-dessous : merci d'avance. David

544

13 days ago

OlivierF67Beginner

asked in Collecter les données

GeoJSON des quartiers administratifs composants les grandes villes françaises

Bonjour,je cherche à récupérer les points de géoloc des polygones qui dessinent des quartiers des villes sur une carte géographique. Des idées ?Merci d’avance pour votre aideAuto-translation 🪄Hello, I am trying to retrieve the geolocation points of the polygons that draw city districts on a geographic map. Any ideas? Thanks in advance for your help

312

14 days ago

David GuillaumeBeginner

asked in Managing data portal

date selector from minute timestamp

Hello,I have a 'timestamp' column of type datetime with minute precision. I would like to create a selector (<ods-select>) that selects and displays only the days (27/11/2024) and not every minutes. Best regards,Auto-translation 🪄Bonjour,J'ai une colonne 'timestamp' de type datetime avec une précision à la minute. Je souhaiterais créer un sélecteur () qui sélectionne et affiche uniquement les jours (27/11/2024) et non toutes les minutes. Cordialement,

140

14 days ago

vmonneyBeginner

asked in Analyser l'usage

Coloring Polar Chart by Category Ranges

Hello everyone,I'm currently working on creating a wind rose chart using the "polar" graph in OpendataSoft. My goal is to color the chart based on wind speed ranges (e.g., 0-4 m/s, 4-8 m/s, >8 m/s), as shown here:However, I’m struggling to achieve this, and currently, the colors seem to be based on the X-axis directions Do you have any suggestions on how to adjust my code or settings to color the wind rose based on wind speed ranges instead of direction?Thanks in advance for your help! code : <ods-dataset-context context="rosedesventstest" rosedesventstest-dataset="rose_des_vents_test"> <ods-chart scientific-display="false" align-month="true"> <ods-chart-query context="rosedesventstest" field-x="direction_azimut" maxpoints="50" stacked="normal" series-breakdown="plage_de_vitesse_m_s" category-colors="{'0-4':'#4eae4a','4-8':'#377eb8','>8':'#e41a1c'}"> <ods-chart-serie expression-y="pourcentage" chart-type="polar" function-y="SUM" color="ra

802

15 days ago

AgOREBeginner

Improve reuse declarationOpen

If a reuse is based on multiple datasets (and it’s the main case) you have to declare the reuse for each concerned dataset, which is tedious and does not add value to the cross-referencing of dataAuto-translation 🪄Si une réutilisation est basée sur plusieurs jeux de données (et c’est le cas principal) il faut déclarer la réutilisation pour chaque jeu de données concerné, ce qui est fastidieux et n’ajoute pas de valeur au croisement des données

170

22 days ago

Nicolas TerpolilliCommunity Manager

Improve how reuses are showcased in a portalWork in progress

Improve how reuses are showcased in a portal

222

22 days ago

AgOREBeginner

Improve datasets distributionOpen

Using the distribution is not easy or intuitive. A global dashboard in the main space, showing what is distributed in which workspace (and with alerts if something is wrong) would be useful.Moreover, the fact that the criteria are cumulative : it’s not possible to choose between AND and OR. It makes the result disappointing and partial.Auto-translation 🪄L'utilisation de la distribution n'est pas simple ni intuitive. Un tableau de bord global dans l'espace principal, montrant ce qui est distribué dans quel espace de travail (et avec des alertes en cas d'anomalie) serait utile. De plus, le fait que les critères soient cumulatifs : il n'est pas possible de choisir entre ET et OU. Cela rend le résultat décevant et partiel.

150

22 days ago

AntoineBeginner

asked in Share data

Issue with Large Data Limit and Advanced Calculations in ods-adv-analysis and ods-aggregation Widgets

Hello everyone,I've been working with the ods-adv-analysis widget and noticed that the output variable seems to be limited to a maximum of 20,000 elements. This constraint is making it difficult to handle large datasets, which are crucial for my project.Additionally, while the ods-aggregation widget works well for basic functions, it only offers simple calculations. For my use case, I need to perform more advanced operations on larger datasets.Does anyone know if there are options or settings to bypass this limit or to perform more complex calculations on large data sets? Any guidance would be greatly appreciated!Thanks in advance for your help!Auto-translation 🪄Bonjour à tous, J'ai travaillé avec le widget ods-adv-analysis et j'ai remarqué que la variable de sortie semble être limitée à un maximum de 20 000 éléments. Cette contrainte rend difficile la gestion de grands ensembles de données, qui sont essentiels pour mon projet. De plus, bien que le widget ods-aggregation fonctionne bi

1006

23 days ago

Page 1 / 2

Hello there!

Ask away and you shall receive an answer.

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Already have an Opendatasoft account ?

Username *

E-mail address *

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Already have an Opendatasoft account ?

Username or Email

Password

Remember me

Forgot password?

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.