Skip to main content

Share data

Create data stories, dashboards and apps, and share your data experiences with the users of your choice.

  • 48 Topics
  • 107 Replies
48 Topics
ajay-hinduja
ajay-hindujaSeeker
asked in Share data
Ajay Hinduja (Switzerland) How do I integrate OpenDataSoft with other platforms?

Hi Everyone, I'm Ajay Hinduja. Born in Punjab, India, and now resides in Geneva, Switzerland (Swiss)I'm working on a project that requires integrating OpenDataSoft with some of our other systems. I'm looking for suggestions on the best way to do this. Has anyone had experience using their native connectors or APIs to integrate with platforms like AWS, Google Cloud, or our internal data warehouses? Any advice on a good starting point or potential challenges would be super helpful.RegardsAjay Hinduja Geneva, Switzerland (Swiss) 

30
ajay-hinduja
Guillaume Perrin-Fabre
Guillaume Perrin-FabreSeeker
asked in Share data
Same "location" for 2 maps

Hello everybody,I have 2 maps in my dashboard (2 different years):  I would like to have a shared “location” between those two.For example, if I zoom on the left one, I want the right one to be zoomed also.Is it possible ?Thanks in advance

152
boris.djakovic
danny.oneill
danny.oneillGuide
asked in Share data
Date in a selector to show month not just year

I have a date selector on a custom view: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-universal-credit-claimants-in-employment-wmca-wards-2025/insight/ The date selector is based on the date field which is set to type of month. However its only showing years. How can I have this show months? <div ods-facet-results="date" ods-facet-results-facet-name="date"ods-facet-results-context="ctxfiltered" ods-facet-results-sort="-alphanum"> <ods-selectselected-values="ctxfiltered.parameters['refine.date']"multiple="false"options="date"label-modifier="name"value-modifier="name"placeholder="Date"></ods-select></div> 

142
morrisjanson
danny.oneill
danny.oneillGuide
asked in Share data
Create A HREF based on dataset filters

I have a little code block on a custom view/code page which links to the dataset. See below:<div class="advanced-kpi--bottom"> <div class="advanced-kpi--bottom-second-stage"> <a class="source" href="/explore/dataset/{{ ctx.dataset.datasetid }}/table/" target="_blank" rel="noopener norefer"> View Source <i class="fa fa-long-arrow-right" aria-hidden="true"></i> </a> </div></div> I would like the href to be dynamic to either use the refine in the dataset context parameters or based on some on page filters. See this page for the filters in question: https://cityobservatory.birmingham.gov.uk/explore/dataset/percentage-households-in-fuel-poverty-wmca-wards/insight/Is this possible? The URL sync is on if that helps. Or do I need to hard code the refine.arealabel into the URL path?

101
Thomas R.
ODS Team
danny.oneill
danny.oneillGuide
asked in Share data
Shaping data to work better with the AI tools

Does anyone have any tips on how to shape data in our portals to work better with the AI tools? The concern from our leadership is someone will ask a question and if the data contains too many filterable items it could return an incorrect result.Is there any guidelines on how to better shape the data to make it easier for AI to understand and provide results?

40
danny.oneill
D
Domi SchusterSeeker
asked in Share data
Refinement by excluding a value possible?

As I’m trying to create a page with the code editor, I’m facing an issue with the refinement of datasets.To automate a line chart for different contexts, so that I can select one dataset of a list of many datasets and use the same ods-chart tag, I want to refine all the contexts before referencing on them in the chart widget. But the important aspect of my question is this: For this refinement, it would be more convenient for me to define the values that should be excluded, instead of the ones that should be included.Is there a possibility to do so?Thank you all in advance! :)

152
D
D
Domi SchusterSeeker
asked in Share data
Series breakdown: unselect some facet values per default

I want to display the evolution of population in all districts of Würzburg with a line chart. For that I use this dataset.In order to compare the districts, I created a series-breakdown on “Stadtbezirk” facet. But since there are 13 districts, this looks a little bit confusing. At the moment, one could unselect several districts by hand by clicking on them in the legend. In this case, it would be more convenient, if there are all but a one ore two districts unselected by default.Is there any possibility to implement this in the HTML or CSS-Code?At the moment, the code for the chart looks like this:<ods-dataset-context context="stadtbezirkehauptwohnsitzaltersgruppen" stadtbezirkehauptwohnsitzaltersgruppen-dataset="stadtbezirke_hauptwohnsitz_altersgruppen"> <ods-chart scientific-display="false" align-month="true"> <ods-chart-query context="stadtbezirkehauptwohnsitzaltersgruppen" field-x="jahr" maxpoints="0" timescale="year" series-breakdown="stadtbezirk">

122
D
C
chris_dixonSeeker
asked in Share data
Highlighting the choropleth tile when refining with an HTML table

I have two datasets, one with polygons and names and one with data.I load the map in the LHS of the screen and use the refine-on-click feature within <ods-map-layer to load a HTML table on the RHS of the screen.However, I’d like to be able to have the map show the selection.I’ve tried using highlight-on-refine="true" but I suspect this doesn’t work because the data on the map is not actually being refreshed!Here is my code:!--scriptorendfragment--><div class="row ods-box"> <ods-dataset-context context="dfesmap,dfesdata" dfesmap-dataset="dfes-primary-polygons" dfesdata-dataset="dfes-2023-primary-data0"> <div class="col-md-8"> <ods-map style="height:560px" scroll-wheel-zoom="true"> <ods-map-layer context="dfesmap" display="choropleth" refine-on-click-context="dfesdata" refine-on-click

303
frederic.passaniti
ODS Team
Yanik Kipfer
Yanik KipferSeeker
asked in Share data
Subscribing to a Calendar

Dear ODS Community,I’m reaching out to see if anyone has experience creating a calendar subscription in ODS. I know you can download calendars via iCal export, but is it also possible to generate an .ics subscription that automatically updates whenever the source data changes?Thank you in advance for your help!

131
Yanik Kipfer
T
TMSSeeker
asked in Share data
Indents in bullet list

Studio page: If you make an bullet list, no automatic indentation is made for the individual bullet points if an enumeration extends over several lines. This does not look nice, like in this example: 

100
T
Johannes Hool
Johannes HoolGuide
asked in Share data
Iframe embeddings without "details-area"

I created a custom visualization for a dataset which is a searchable table in our corporate style. When embedding this visualization through an iframe the details-area is sticking to the bottom of the frame.In the following example you can see the rather prominent details-area at the bottom of the element.Is there a possibility to suppress this element? At the beginning I thought I could do this with the url parameter “datasetcard” (see example link below). However, I must have misinterpreted this parameter as it does not influence the details-area.<iframe src="https://data.bl.ch/explore/embed/dataset/adressen-der-gemeindeverwaltungen-januar-2025-kopieren/webtabelle/?disjunctive.name&disjunctive.plz&disjunctive.ort&static=false&datasetcard=false" width="400" height="300" frameborder="0"></iframe>Any help would be greatly appreciated.Best,Johannes

543
Johannes Hool
T
TMSSeeker
asked in Share data
Dashboard without visible dataset?

We have created some dashboards for students that are not yet publicly visible. The charts and KPIs on the dashboards are very aggregated, but the underlying datasets could be sensitive in terms of data protection. Is there a way that the datasets can only be used for the dashboards without a visitor to our ODS website being able to access the dataset itself?An alternative would be to hide some columns in the data set, but these are included again when exporting. Or is there a restriction option so that only the data that is visible on the ODS website can be exported?As an addendum: the dashboards were created with no-code-editor.

505
A
Yanik Kipfer
Yanik KipferSeeker
asked in Share data
Sorting a stacked bar pl

Dear ODS Community Is there a way to sort a stacked bar plot according to the total value of the individual bars. Looking at the example in the image, I would like the bar for “Wohnzonen” to be on top and the bar for “weitere_Bauzonen” to be at the bottom. Here is the code for the barplot: <ods-chart scientific-display="false" single-y-axis="true" labels-x-length=100 label-x="Hauptnutzung"> <ods-chart-query context="dvsareraum20250224" field-x="ch_hauptnutzung_name" reverse-stacks="true" stacked="normal" series-breakdown="standueberbauung_aggregiert" sort="serie1-1"> <ods-chart-serie expression-y="flaeche_ha" chart-type="bar" index="0" function-y="SUM" color="range-custom" display-values="true"

362
Yanik Kipfer
Yanik Kipfer
Yanik KipferSeeker
asked in Share data
GPT-Model for API and Visualizations

Has anyone tried training a GPT-Model using the ODS documentation to be able to write HTML code that can be directly used in ODS to create visualizations?

210
Yanik Kipfer
R
RyanGuide
asked in Share data
Studio Editor Graphs

Me again!Ive been looking at the studio editor for creating pages, is there anyway to make the charts cumulative? For example im wanting to total the amount of generation in one of our datasets over the last 5 years or so, currently i can only get it to sum the amount in 2020, then 2021, 2022 etc, and not add these figures to show a trend over that time period. Apologies if its very obvious but currently I cant see it! Thanks Ryan

491
Rémy
Community Manager
M
mehdiSeeker
asked in Share data
Help with Adjusting Label Rotation and Truncated Y-Axis Labels

Hi everyone,I’m currently working on a couple of charts and need some help with the following: Removing Label Rotation on X-Axis: I have a column chart where the X-axis labels are rotated by 45°. I would like to keep them horizontal (no rotation). I’ve tried using the x-label-rotation="0" attribute, but it doesn’t seem to work. Does anyone know how to remove the rotation and keep the labels straight? Fixing Truncated Labels on Y-Axis: In another chart, the labels on the Y-axis are too long and are getting truncated. I’d like to ensure that the full labels are visible without cutting off any text. Does anyone have a solution for adjusting the Y-axis to accommodate longer labels? Any help or suggestions would be greatly appreciated!Thanks in advance!Auto-translation 🪄Bonjour à tous, Je travaille actuellement sur quelques graphiques et j'ai besoin d'aide pour les points suivants : Suppression de la rotation des étiquettes sur l'axe des X : J'ai un graphique à colonnes où les étiquettes

461
M
ODS Team
R
RyanGuide
asked in Share data
Elements of maps showing on top of pop ups

Hi All! Maybe ( and hopefully ) a simple one, has anyone else had problems with pop ups not appearing on top of certain elements on their page? See below where certain parts of the map show over the top of the pop up. Is there anything to include in the code to ensure the pop-up appears over everything?  Auto-translation 🪄Bonjour à tous ! Peut-être (et j'espère) une question simple, quelqu'un d'autre a-t-il eu des problèmes avec des fenêtres contextuelles qui n'apparaissent pas au-dessus de certains éléments de sa page ? Voir ci-dessous où certaines parties de la carte s'affichent au-dessus de la fenêtre contextuelle. Y a-t-il quelque chose à inclure dans le code pour garantir que la fenêtre contextuelle s'affiche au-dessus de tout ?

342
R
David Guillaume
David GuillaumeSeeker
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

1296
M
ODS Team
boris.djakovic
boris.djakovicGuardian
asked in Share data
fgb harvesting problem

Hello dear community,We have a small problem with the harvesting on opendata.swiss - we are receiving the following error message for all data we are harvesting on opendata.swiss:Error Message: 400 Client Error: Bad Request for url: https://data.bs.ch/api/v2/catalog/datasets/100168/exports/fgb  Apparently, there is an issue with the fgb format. Had annyone the same issue?Best regards from Basel,BorisAuto-translation 🪄Bonjour chère communauté, Nous avons un petit problème avec la récolte sur opendata.swiss - nous recevons le message d'erreur suivant pour toutes les données que nous récoltons sur opendata.swiss : Message d'erreur : 400 Erreur client : Mauvaise demande d'url : https :/ /data.bs.ch/api/v2/catalog/datasets/100168/exports/fgb  Apparemment, il y a un problème avec le format fgb. Quelqu'un a-t-il eu le même problème ? Meilleures salutations de Bâle, Boris

1034
D
natalia.morozova
Community Manager
natalia.morozovaCommunity Manager
asked in Share data
Afficher le nombre de jeux de données

Bonjour, est-il possible d'afficher le nombre de jeux de données dans le catalogue de façon dynamique ? Auto-translation 🪄Hello, is it possible to display the number of datasets in the catalog dynamically?

181
L
ODS Team
Y
yvonneGuardian
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.

292
Y
T
Tom SantosSeeker
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

633
Rémy
Community Manager
O
orhan.saeediSeeker
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

593
O
M
matthew.parrySeeker
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"

622
R
A
AntoineSeeker
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

1486
A

Hello there!

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