☀️ Summer update: unleashing the power of your Huwise portal !
Anything related to data
Recently active
Hello everyone 👋It’s already been one year since our community was launched — and what a year it’s been!A huge thank you to everyone who has participated, asked questions, shared ideas, offered answers, or simply taken the time to read and learn here. 🙏Today, we’re opening a new chapter: Opendatasoft becomes Huwise.A new name, a new energy, but the same drive to grow together through the collective wisdom of our community 💫And to celebrate this rebranding, we’re launching our first big community challenge 🏆👉 Theme: “Your best stories or successes with Opendatasoft”Share your memories, proud moments, fun anecdotes, or big wins with Opendatasoft:a funny or unexpected story a project you’re proud of an idea or collaboration that started thanks to Opendatasoft or simply a meaningful moment from the past few yearsYou’ll also notice new badges appearing (first post, first reply, first accepted answer, and more) — and this challenge is your chance to earn the exclusive “Huwise Pioneer” b
We are at a monumental turning point. As generative and agentic AI flood the market, organizations face a critical choice: allow technology to cause information chaos, or harness it intentionally to amplify collective intelligence.The freshly co-created Data Voices 2026 Manifesto gathers insights from nearly 100 Data & AI leaders across international industries to establish a definitive roadmap for the next four years.Here is a look at the 6 strategic predictions that will define the AI-first enterprise by 2030, along with the immediate actions you need to take today. 📋 The 6 strategic predictions for 2030 # Prediction The core insight 1 Data Leaders as Business Strategists The CDO/CTO will evolve from a technical executioner into the CEO’s core strategic partner, balancing technical foundation with real ROI. 2 Effortless Data Democratization Data-driven culture will become organizational DNA. Every employee will independently leverage data, backed by intelligent age
I’ve been investigating options for accessing the data on our portal using AI assistants, mainly Claude code. I previously posted my experience of a REST to MCP adapter, which works, but is a bit clunky and not very token efficient. I have recently experimented with a new library called mcp2cli which enables the coding agent to use CLI commands to query data on our portal.MCP2CLI can create a skill which introspects the swagger.json - which is published under the portal’s API tab, to understand the explore API of the portal. This enables the coding agent to discover datasets, understand their structure and create SQL queries to return filtered and aggregated data. The skill is an alternative approach to MCP servers that is more token efficient due to progressive disclosure and the use of a command line interface to query the data. I iterated over creation of the skill several times to improve it.My limited testing of the skill I created indicates that it is quite accurate and token -
Hey community! 🚀Ready for a new challenge? 🏆This round is all about Forms.We’d love to hear how you’re using the Forms feature - the context, how you set it up, what data you collected, and, most importantly, what it changed for you.Did it help you…✨ save time or streamline a workflow?✨ build a new asset or surface insights?✨ collaborate better across teams or with users?✨ or something else entirely?Share your use case in the thread, check out others’ ideas, and don’t forget to react to your favorites! 👍💬The submission with the most likes will earn the new Monthly Challenge badge 🎖️Let the inspiration and the competition begin! 🔥Monthly challenge badge
Hi allI’ve been using Claude Code quite a lot for developing software and doing analysis. It’s an agentic AI coding assistant in the CLI if you haven’t come across it. Anthropic (the parent company) developed a protocol called MCP to help the AI use external resources like APIs.Someone has developed a tool to take openapi or swagger API specifications and turn it into MCP tools. What this means is that you can ask Claude Code, in natural language, questions about your data, and it will translate this, quite well into code to send a request to the API and return data. HuWise have done something similar on the portal in their “Explore data with AI” feature, but this is a bit more powerful for deeper analysis - but requires some setup and a Claude account and Claude Code.I simply cloned the repo and asked Claude to create MCP tools from the swagger json for my portal, and it did the rest.Here is my cloned repo, with the ods_server.py script providing the mcp tools for my portal. Full desc
Hello, I can see that the region ID - Name used for Japan in OpenDataSoft follows the FIPS standard. I also see in different sources that FIPS is no more used since 2008. Do we know why OpenDataSoft is still using this norm ? is there a way they could update to use one of the used norms in the whole world now ( JIS X 0401 or ISO )
Are there plans to add more mapping capability for Studio Maps - for example clusters, dots and shapes and heat maps - same functionality that is shown in Map Builder?
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
Is it possible to remove the label indicating the cluster count ? - or at least the option to style it - so the label has the same colour as the icon behind it?
Dear Support Team,I am currently trying to display data in a chart, and I have encountered an issue. The chart is displaying the years along the X-axis, but some years are not being shown, likely due to space constraints.Is there a way to force the diagram to display the missing years, such as 2017, 2019, and so on?Thank you for your assistance. I look forward to your guidance on how to resolve this issue.Best regards,Boris
Hello Community,It seems many of you are looking to create content that helps your users get more value from the portal.We’d love to know how you currently support your users, and how we can make it easier for you.Quick poll, takes 2 min tops. Mind giving it a go?👉 Go to the poll.Thanks a ton!
I’ve been trying to use the Geofilter.polygon to refine the results in a dataset per this documentation:https://userguide.opendatasoft.com/en/articles/2257346#:~:text=geofilter.polygon,%2C2.386968)However it always looks like it does a text search in the records. Is there a setting I need to activate at the dataset level to accept geofilter options?
I’ve found this article very interesting : https://open.substack.com/pub/benn/p/disband-the-analytics-team
Hello, I’m student, and I need to use OpenDataSoft for French municipalities per year, I want to know if it’s possible to get an API key to get this kind of data without limitations please. This is the data that I need between 2015 and 2024. https://public.opendatasoft.com/explore/embed/dataset/georef-france-commune-millesime/table/?disjunctive.reg_name&disjunctive.dep_name&disjunctive.arrdep_name&disjunctive.ze2020_name&disjunctive.epci_name&disjunctive.ept_name&disjunctive.com_name&disjunctive.ze2010_name&disjunctive.com_is_mountain_area&disjunctive.bv2022_name&sort=com_name
Hello Community!Great news—posts are now available in 9 different languages! 🎉If a post is in a language you’re not comfortable with, just click “Translate” below the post and select your preferred language. AI will handle the rest. 📌 Bonus: You can also translate all replies to a post at once, just like this: Try it out and let us know what you think! 🚀
Hi we are trying to truncate the first 5 characters of a field and for some reason the Replace via Regular Expression processor doesn’t seem to ‘work”We have tried:^(.{1,5})(?:|$)Regex101.com seems to match it correctly and which replaces the first 5 characters with blank so then we tried this^.{5}(.*)which seems to replace all of it with a blank… Help please. If anyone can create a small library of useful regex strings for use that would be really appreciated!
Hello Community, the New Year is approaching and I thought we could share a few things - personal achievements, movies, songs, books, and other stuff (in data or not) — that have inspired us over the last 12 months.One of my achievements: Community launch, love it!🤩 Another one: 16 min in a wall sit challenge with my colleagues - it makes me question my career choices 🤔😅 My fav podcast of the year (in French): Raphaël Gaillard - Notre cerveau ne se supporte plus: on pharmacology, psychology, psychedelics, and brain chips…What are yours??Auto-translation 🪄Bonjour la communauté, la nouvelle année approche et j'ai pensé que nous pourrions partager quelques éléments - réalisations personnelles, films, chansons, livres et autres choses (en données ou non) - qui nous ont inspirés au cours des 12 derniers mois. Une de mes réalisations : le lancement de la communauté, j'adore ! 🤩 Une autre : un défi de 16 minutes assis contre un mur avec mes collègues - cela me fait remettre en question m
Bonjour, j’aimerais savoir comment pourras-je faire pour creer un clé API sur l’api BODACCAuto-translation 🪄Hello, I would like to know how I can create an API key on the BODACC API.
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>
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
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.
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 !!! 😃
Hello everyone, I'm sharing with you our new dashboard on baby names in our region.I hope this will inspire your creations. If you have any technical questions, I'll be happy to answer them and share the code. 😉Auto-translation 🪄Bonjour à tous, je partage avec vous notre nouveau tableau de bord sur les prénoms de bébé dans notre région. J'espère que cela inspirera vos créations. Si vous avez des questions techniques, je serai ravie d'y répondre et de partager le code. 😉
Hello to all dear members of the ODS community, We would like to share with you our latest dashboard, which presents several key figures from our canton (and by district and municipality) in various fields. All feedback is welcome, and we hope it will be a good source of inspiration.🤗✨Link✨ SStat FribourgAuto-translation 🪄Bonjour à tous chers membres de la communauté ODS, Nous souhaitons partager avec vous notre dernier tableau de bord, qui présente plusieurs chiffres clés de notre canton (et par district et commune) dans divers domaines. Tous les retours sont les bienvenus et nous espérons qu'ils seront une bonne source d'inspiration.🤗✨Lien✨ SStat Fribourg
Dear Support Team,I am reaching out with a technical question regarding my project.I am encountering an issue with initializing (lastdate) . Specifically, I need this variable to be correctly set in order to use it in a dropdown menu. This logic was working fine previously, but today I noticed that it no longer functions as expected. Here is a simplified snippet of my code: <div class="sticky-content" ng-init="variables = {}"> <div ods-adv-analysis="dateanalysis" ods-adv-analysis-context="myctx" ods-adv-analysis-select="max(jahr) as maxdate"> </div> <div class="advanced-kpi--top"> <h2> <strong>Filtern nach Spital und Jahr:</strong></h2> <div class="shared-width-ods-selects"> <div ods-facet-results="reglist
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.