Skip to main content

Discussions

Ask for help or share an insight.

71 Topics
O
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

50
O
20 hours ago
boris.djakovic
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>

60
boris.djakovic
1 day ago
Y
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.

70
Y
1 day ago
T
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
T
5 days ago
Y
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
Y
ODS Team
5 days ago
G
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
Y
ODS Team
5 days ago
B
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
B
6 days ago
O
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
O
7 days ago
boris.djakovic
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
boris.djakovic
7 days ago
T
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
T
7 days ago
Nicolas Terpolilli
Community Manager
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

20412
L
8 days ago
boris.djakovic
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

60
boris.djakovic
8 days ago
M
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
R
13 days ago
David Guillaume
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
David Guillaume
13 days ago
David Guillaume
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
David Guillaume
15 days ago
A
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
A
24 days ago
R
RenatoFBeginner
asked in Managing data portal
Difference between Temporal Period and Temporal Coverage

HelloI wanted to enrich our metadata with the temporal information for datasets where this makes sense. Now, I am a bit confused where I should fill this out. We have two options that have the exact same content, as far as I am concerned. There is:Temporal Period: A text field Temporal Coverage: Two fields (“Temporal coverage start date“ and “Temporal coverage end date“) that are date fields of the form “DD/MM/YYYY hh:mm:ss”Can anyone please elaborate the difference between the two options and their intended use cases, and which field is intended for my use, i.e. to document the first and last date that appears in any date column of the dataset? Best regardsAuto-translation 🪄BonjourJe voulais enrichir nos métadonnées avec les informations temporelles pour les ensembles de données lorsque cela a du sens. Maintenant, je ne sais pas trop où je dois remplir cela. Nous avons deux options qui ont exactement le même contenu, en ce qui me concerne. Il y a :Période temporelle : Un champ de tex

271
Benwa
ODS Team
27 days ago
N
Nadia VBXBeginner
asked in The world of data
Unix timestamps conversion

Hi everyone ! I would like to use a processor to convert Unix Timestamps into DateTime in the format %d/%m/%Y %H:%M:%S (‘1729698397000’ => ‘23/10/2024 15:46:37’). Do you have any idea what expression to use?My source is the JC Decaux API https://developer.jcdecaux.com/#/opendata/vls?page=getstarted.PS: for some reason, I don't want to use the dataset that already exists on the Data Hub.Thanks in advance for your help!!! 😃Auto-translation 🪄Bonjour à tous ! Je souhaiterais utiliser un processeur pour convertir les Timestamps Unix en DateTime au format %d/%m/%Y %H:%M:%S (‘1729698397000’ => ‘23/10/2024 15:46:37’). Avez-vous une idée de l’expression à utiliser ? Ma source est l’API JC Decaux https://developer.jcdecaux.com/#/opendata/vls?page=getstarted.PS : pour une raison quelconque, je ne souhaite pas utiliser le jeu de données qui existe déjà sur le Data Hub. Merci d’avance pour votre aide !!! 😃

414
N
27 days ago
danny.oneill
danny.oneillBeginner
asked in Managing data portal
Delete records with value less than 5000

I am being really dense here. But I cannot fathom how to use the ‘Delete records processor’ to delete all records where the value is below £5,000.I have tried entering = < 5000 into the field but that doesnt function as expected. Is it possible to remove rows based on a filter?Auto-translation 🪄Je suis vraiment un peu con. Mais je ne comprends pas comment utiliser le « Processeur de suppression d'enregistrements » pour supprimer tous les enregistrements dont la valeur est inférieure à 5 000 £. J'ai essayé de saisir = < 5000 dans le champ, mais cela ne fonctionne pas comme prévu. Est-il possible de supprimer des lignes en fonction d'un filtre ?

161
Benwa
ODS Team
27 days ago
boris.djakovic
boris.djakovicBeginner
asked in Share data
Table View Customization

Hello ODS-Community,I hope you are doing well. I have a quick question regarding the table view feature. Is it possible to customize the embedded table so that I can change the order of the columns and display only the desired columns?I would greatly appreciate your guidance on this.Thank you for your help!Best regards,BorisAuto-translation 🪄Bonjour ODS-Community,J'espère que vous allez bien. J'ai une petite question concernant la fonction d'affichage du tableau. Est-il possible de personnaliser le tableau intégré afin de pouvoir modifier l'ordre des colonnes et afficher uniquement les colonnes souhaitées ? J'apprécierais grandement vos conseils à ce sujet. Merci pour votre aide ! Cordialement,Boris

313
Benwa
ODS Team
27 days ago
danny.oneill
danny.oneillBeginner
asked in Share data
Multiple aggregations for use in one visual

I am looking for some guidance.I have a dataset containing values for Birmingham wards, England and the Region.I would like to have a visual (Column chart) which shows each ward. But then a reference line to show the average for England and the Region based on their latest value.At the moment I am doing this using variables I define. But I would like it to autmatically figure out the latest year and return the latest value for England and the Region rather than me hardcoding it into the variables. My Code looks like this;<!--Variables Start--><div ng-init=" valuelabel = 'Value (%)'; maphigh = '8,48,107'; maplow = '198,219,239'; decimalprec = '1'; complatestperiod = '2021'; compBirmlatestvalue = '10.8'; compEnglatestvalue = '6.4'; compWMCAlatestvalue = '8.9' "> <!--Variables End--> <ods-dataset-context context="ctxenglat

323
danny.oneill
28 days ago
R
RyanBeginner
asked in Organize data
Undelete Datasets

Is there anyway to recover a deleted dataset? May of made a small error!ThanksRyanAuto-translation 🪄Existe-t-il un moyen de récupérer un ensemble de données supprimé ? J'ai peut-être fait une petite erreur ! Merci Ryan

221
Rémy
Community Manager
30 days ago
F
FadwaBeginner
asked in Organize data
Issue with Extracting Multiple Plain Text Blocks with the extract text processor.

Hello everyone,I’m currently facing a challenge with extracting plain text from HTML content, and I’m looking for some advice on how to resolve it.The issue arises when I try to extract all text segments located between various HTML tags. I’ve been using a regular expression to capture the text, but I’ve encountered a limitation where only the first occurrence of text is retrieved, while subsequent occurrences remain unextracted. The regular expression I’m using is:>(?P<texte_brut>[^<>]+)<This works for capturing the first block of text but doesn’t return the remaining segments found within the other tags. My goal is to extract all text occurrences embedded between HTML tags in a single process.For instance, given the following HTML:<p>Chers voyageurs,</p><p>En raison de travaux sur la commune de Vitrolles, les lignes 7 et 20 sont déviées du 25/09 au 31/12 de 6h à 21h.</p><p><strong>Arrêts non desservis :</strong></p>&lt

421
B
ODS Team
1 month ago
David Guillaume
David GuillaumeBeginner
asked in Share data
time series

Dear community,I’m working with time series data, and my data corresponds to a production measured every 10 minutes (each line correspond to the production for 10 minutes). Like the following:    Timestamp Production 01.01.2024 00:00 12 01.01.2024 00:10 4 01.01.2024 00:20 16  I haven’t found a straightforward way to display a line plot with time on the X-axis and the production value on the Y-axis. The examples I’ve seen are similar to the screenshot below (function-y="SUM" and timescale="hour").This solution works if each observation corresponds to 1 hour/minute... but what should I do in my case where one row corresponds to 10 minutes? I hope my question is clear, and I thank you in advance for your valuable help.Best,DavidAuto-translation 🪄Chère communauté,Je travaille avec des données de séries chronologiques, et mes données correspondent à une production mesurée toutes les 10 minutes (chaque ligne correspond à la production pendant 10 minutes). Comme ce qui suit :    

561
E
ODS Team
1 month ago
E
erikschaapBeginner
asked in Organize data
Base64 pictures

 I have a dataset containing Base64 pictures. I want to show the Base64 picture on the map. But when I try that, it shows the Base64 code instead of the picture. So it will not translate the Base64 code to a picture. However, when I use the Base64 code in the Studio, I can add the field containing the Base64 codes as the picture field in the popup configuration (see example picture).Is there a solution for this? Auto-translation 🪄J'ai un ensemble de données contenant des images Base64. Je souhaite afficher l'image Base64 sur la carte. Mais lorsque j'essaie, le code Base64 s'affiche au lieu de l'image. Il ne traduira donc pas le code Base64 en image. Cependant, lorsque j'utilise le code Base64 dans le Studio, je peux ajouter le champ contenant les codes Base64 comme champ d'image dans la configuration contextuelle (voir l'image d'exemple). Existe-t-il une solution à ce problème ?

432
E
1 month ago

Hello there!

Ask away and you shall receive an answer.
Terms & ConditionsCookie settings