Skip to main content

Rill 0.78 - Default Filters for Canvas, Dynamic Markdown, Pivot Display Limits, Query Attributes

· 3 min read
note

⚡ Rill Developer lets you transform datasets with SQL and build fast, exploratory dashboards. Rill Cloud enables collaboration at scale.

👉 Install Rill Developer • Join our Discord • Deploy to Rill Cloud

release-0 78

Default Filters for Canvas​

Set up default filters and pin your most important dimensions for quick access! When you're working with large metrics views, it can be a daunting task to sift through all the available dimensions and measures. With default filters, you can build Canvas dashboards that automatically set filters on dimensions by default and pin the ones that matter most—so your users don't have to hunt for them!

Dynamic Markdown​

We're introducing dynamic content in Markdown components! You can now template Metrics SQL queries directly into your Canvas dashboard that automatically react to user filters, creating a fully dynamic markdown experience. Want to take it even further? You can render HTML too! Plus, we're making the backend endpoint public so you can easily build your own programs and workflows that need access to templated data.

Pivot Display Limits​

Introducing a toggle to limit the number of dimensional rows that are visible in the pivot table. This allows you to reduce the cognitive load when interacting with a pivot table. Note that this is a display limit only, totals, exports and reports still operate on the full dataset.

Query Attributes​

If you're using ClickHouse, you can now append query attributes that access dynamic user attributes. This is super useful if you want to send along, for example, a user ID or email to route or filter views in ClickHouse based on Rill user context. Or if you want to build your own usage reporting based on queries issued to your ClickHouse instance.

Bug Fixes and Improvements​

Canvas​

  • Fixed canvas component map reactivity issues
  • Improved support for canvases without time dimension
  • Fixed time dimension incorrectly appearing in categorical dimensions for canvas
  • Fixed URL initialization flag sequencing

AI Chat​

  • Fixed dev chat button incorrectly showing up in deploy pages
  • Fixed new conversation data not updating in the history dropdown
  • Improved the AI's "thinking" aesthetic

Pivot Tables​

  • Fixed pivot sidebar scroll behavior
  • Fixed left alignment of pill labels for pivot
  • Fixed pivot table filter click and drag behavior
  • Fixed spaces in measure/dimension search
  • Fixed contains filter not applying to dimension table
  • Fixed explain range feature clearing unnecessarily
  • Added initial sort to address sorting issues

Deployment​

  • Fixed deploy via API ignoring subpath
  • Fixed blank project page after redeploy
  • Fixed deleted GitHub repos causing issues

Data Sources​

  • Fixed ClickHouse JSON type in table listings
  • Fixed issue where during full reload, processed partitions were dropped if error occurred
  • Fixed implicit connectors not being detected for secret SQL generation

UI/UX​

  • Fixed truncation tooltip behavior
  • Updated language for full refresh to be more serious
  • Fixed move citation URLs to buttons in embed