Here's a cool experimental feature that our team hacked together: A Google spreadsheet extension that allows you to self-serve BI datasets directly in Google Sheets.

It works in 4 simple steps

1. Connects to BI environment
2. Let end users self-serve BI datasets (like a pivot table)
3. Sync results directly as google sheets table
4. Set custom frequency for refreshing data

This will be very useful for users who prefer working with spreadsheets, yet need the reliability of a centralized BI system.

Note: This is an experimental project (born out of our recent hackathon). If you’re a customer of Holistics and interested, fill our Early Request Form here and we’ll let you know when it’s available for beta.

Now, admins, and analysts can grant explorers the create/edit/delete permission to dashboards in the public workspace. Once granted, explorers will have the Quick Edit experience to create/edit dashboards:

• Only UI-based editing, no code-based editing, and
• No branching request/merging is required

Notes:

• All changes are saved as code in your repository for consistency and traceability.
• This feature will be available for not only the 4.0 but also the 3.0 Holistics version.
• Explorers still won’t be able to create/save canvas dashboards into their own Private Workspace

Try it out and let us know how it works for you! 😊

You can now set up Data Schedules (or Alerts) for multiple Slack channels! 🎉
This enhancement is designed to give you more flexibility and control, making it easier to manage and streamline your data deliveries to Slack.

Try it out and let us know how it works for you! 😊

You can now export entire dashboards directly to Excel! 🎉

This update is designed to saves you time and effort, letting you download your dashboard as a single Excel file in just a few clicks.

Level Up Your KPIs with New Styling Options ✨ 🌟 😍

With our new styling options, you are now empowered to make your KPIs more visually impactful. Adjust font size, font color, text alignment, and explore unique styles for each comparison type 🙌

Ready to give your KPI Metrics a dazzling makeover? Share your styling creations with us! ✨🎉

Introduction​

AQL is getting an upgrade! No more static calculations. You can now make AQL dynamic by combining it with Query Parameters.

This means AQL definitions can adjust based on user inputs via the Dashboard Filter, and you'll be able to do Dynamic fields selection (dynamic dimensions, dynamic metrics)

Demo​

Dynamic Dimensions Selection​

Dynamic Metrics Selection​

More details on how to set up​

If you want to understand more details on how to set up this, please refer to our doc about Advanced Use Cases

Say goodbye to the hassle of manually resolving merge conflicts!

We’re thrilled to introduce the Quick Resolve option, which allows you to:

• Instantly choose whether to keep your version, or the incoming version for each conflicted file.
• Apply your choice to all files at once, so you can quickly return to your tasks.

For those who prefer a more hands-on approach, the Manual Resolve option remains available, letting you sort out the conflict in the code editor.

Check it out in action:

We’ve made working with tables easier and more intuitive! With these updates, you can now:

• Change aggregations and time grains
• Auto-size columns
• Rename columns
• Remove columns

All directly on your tables, giving you more control and flexibility in your workflow.

Give it a try and let us know what you think! 😊

Holistics now supports two-factor authentication (2FA) for password-based login.

Two-factor authentication (2FA) adds an extra layer of security to your Holistics account. Once enabled, it requires an additional code from an authenticator app (e.g., Authy, Google Authenticator, etc.) along with your email and password, ensuring only you can access your account.

The admin can require two-factor authentication for all users to enhance the organization’s security.

To learn more, please go to Two-factor Authentication for detailed settings.

To follow up on the Dynamic Data Sources feature, this is another cool feature that might be useful, dynamic schemas

📊 ​Dynamic Schema for Dev/Prod Environments​​

For those of you who separate dev and prod environments based on schema (or datasets in BigQuery) instead of the actual data source, we’ve got you covered with our Dynamic Schema option.

This feature lets you switch schemas easily using basic string interpolation in your model's table_name property.

Here’s a quick example to show how it works:

// This is for dynamic schema use case by branch  

const current_branch = H.git.current_branch
              
const dynamic_schema = 
  if (current_branch == 'master') { 'prod' } 
  else if (current_branch == 'staging') { 'stg' } 
  else { 'dev' }

// in Table Model
model users {
  type: 'table'
  data_source_name: 'your_db'

  // dynamic schema in table name
  table_name: '${dynamic_schema}.users'
}

// in Query Model
model derived_users {
  type: 'query'
  data_source_name: 'your_db'
  
  // dynamic schema in a query
  query: @sql select * from ${dynamic_schema}.users ;;

}

🛠️ What does this mean?​

You can automatically point to the correct schema based on the branch you’re working on—making your workflow even smoother!