Recently active topics

Dear Support Team,we have received the following request from a user regarding dataset https://data.bs.ch/explore/dataset/100120/, which we would like to forward to you for further investigation.The user reports an inconsistency in the handling of the field vu_jahr: The field is defined as a date in the dataset schema. However, when exporting the dataset, the field appears to be delivered as a string. When querying the dataset via ODSQL (using a SELECT vu_jahr GROUP BY vu_jahr query), the result returns proper datetime values (e.g. 2011-01-01 00:00:00+00:00, etc.). This inconsistent behavior causes issues in the user’s synchronization process. While they have implemented a workaround on their side, they asked whether this could be fixed at the platform level.Example query used by the user:https://data.bs.ch/api/explore/v2.1/catalog/datasets/100120/exports/csv?lang=de&timezone=Europe%2FBerlin&use_labels=false&delimiter=%3B&select=vu_jahr&group_by=vu_jahrCould you

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

Hi all,If a dataset contains both a geopoint and a geoshape, is there anyway to select which will be displayed when you add it onto a map for example ? By default it seems to show the shapes Thanks RyanAuto-translation 🪄Bonjour à tous,Si un ensemble de données contient à la fois un géopoint et une géoforme, est-il possible de sélectionner celui qui sera affiché lorsque vous l'ajouterez sur une carte par exemple ? Par défaut, il semble afficher les formes Merci Ryan

Hello,I have a dataset with a “date” variable and I would like to dynamically assign the start date of my graph as the last date in my dataset -20 years. I can use an ods-adv-analysis to obtain the latest date in my dataset, but I can't subtract 20 years from it. Furthermore, I can hardcode the start date, but not using a dynamic variable:<div ods-adv-analysis="maxdate" ods-adv-analysis-context="pibcroissancetrimestre" ods-adv-analysis-select="max(date) as maxdate" > {{last_date = maxdate[0].maxdate; ""}} {{last_date}} {{ pibcroissancetrimestre.parameters['q.from_date.date'] = 'date>=2005-09-30T00:00:00+00:00 '; ""}}Can someone help me fix this code?Thanks in advanceNathan

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