Learn & share

If you need to accurately calculate the gap between two key moments, the DateDiff function in the Expression processor is your best ally. 🔍 What is DateDiff?It’s a date and time function that counts the number of units (days, hours, minutes, etc.) between two datetime expressions. 🛠️ How do you implement it?In your Expression processor, the syntax usually follows this logic:DateDiff(unit, start_date, end_date)Unit: choose what you want to count ("day", "hour", "minute", etc.). Start_date & End_date: the two datetime fields you want to compare. 📖 Concrete exampleImagine you want to calculate the age of an alert in days:

Hello Community!We’ve seen so many of you making the leap to our New Experience, and frankly, we’re a little jealous of how good some of your setups are looking.Transitioning to a new interface is more than just a fresh look—it’s about building a more powerful data portal for your teams and users. Now, we want to see how you’ve made it your own.The Challenge 🏆: We’re calling on all Clients and CSMs to drop a screenshot of your newly designed portal in the comments below. Whether you’ve relooked your home page, rebuilt your catalog, or just simply turned it on—we want to see it!How to participate :Snap a shot: take a screenshot of your favorite view in the New Experience. Tell us why: share one "pro-tip" or favorite feature about your new experience. Tag your partner: clients,

Hello everyone,The Huwise experience is evolving!The Huwise Academy now offers a learning path to guide you step by step through activating the new experience. 🎯 Why follow this path?The new experience isn’t just a visual update—it’s a redesign of how your users interact with the platform. This path gives you the keys to:Master the new features and navigate the interface with ease. Optimize your datasets to align your engagement strategies with Huwise’s new technical capabilities. 📚 What’s included:Interface exploration: understand the structural changes. Optimal setup: configure the platform for a smooth activation. Best practices: explore platforms that have already adopted the new experience.Bonus:

 At Huwise, your satisfaction and the progress of your projects are our top priorities. To ensure fast response times and high-quality follow-up, we have structured our communication channels.This article helps you identify the right point of contact so each request is handled by the relevant expert as quickly as possible. 🛠 1. "Self-service": your first stepBefore reaching out to us, remember :The User Guide which brings together all our technical and functional documentation. The Academy which centralizes all tutorials and courses on how to use Huwise products and services. The Community which shares use

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 ski

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 ch

Discover our Sources of inspiration page, a collection of real-world use cases showing how our users leverage, share, and create value from their data with Huwise.From public organizations to private companies, these concrete examples highlight:How data is transformed into impactful use cases How our platform supports data sharing and visualization How real projects inspire new ideas and innovationWhether you're starting a new project or looking to unlock more value from your data, these use cases are here to spark ideas, guide decisions, and demonstrate what’s possible.

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 re

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 )

🎯 We’re happy to announce the launch of the Huwise status page, a tool designed to efficiently share information about the status of our services.From now on, the fastest and most up-to-date way to get this information is to check the Huwise status page directly!(Of course, if your incident isn’t listed, feel free to contact us!) 💡  Visibility and transparency 🔍 Ease and relevance: You can check the status of Huwise services at any time—and even view it region by region.📢 Effective communication: Automatic notifications (email, webhooks, etc.) keep you instantly informed of any incident.⏱️ Real-time information: The page is connected to our monitoring tools, allowi

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']"

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

Hello Community,We want to improve our ressources—User Guide, Academy, and Community. But we need your help to fine-tune what works and what doesn’t.Do you want more videos? Access from the platform? Content for the end users?Take a few minutes to share your thoughts by answering our short questionnaire. It’s just 8 questions—your feedback will shape the future of your learning experience.💡 Take the questionnaire & make your voice count!Big thanks for helping us improve! 🙌

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 1

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.