New! Check out our free BigQuery cost analyzer - built with Hashboard BI-as-code

Filter and Group Array Values

Say hello to array attributes! Hashboard now natively handles analyzing array types from a model. You can filter and group array elements while preserving your original measures, attributes and calculations.

Let’s say you have a Hashboard model for marketing campaigns. Each campaign has multiple ‘tags’ that you wanted to analyze: (eg. ‘drip campaign 2’ and ‘enterprise customer’). Previously you’d have to create a new model to analyze the tags instead of being able to analyze them with your original campaigns model. Array attributes let you analyze all your campaign metrics consistently across the multiple tags. So you can view performance for your ‘enterprise customers’ compared to your ‘drip campaign 2,’ even though they are overlapping.