Beast Mode

Beast Mode

Beast mode to only show matching creative types in grouped bar chart?

We are using a grouped bar chart to compare client and typical engagement rates by creative type (see 1st screen grab). The report is filtered by a SalesQuote field where client results have one value and typical results='Banner Average'. These are unique rows in the data set (see 2nd screen grab). There are six 'Banner Average' rows for every possible creative type (these represent the past 6 months of performance across all creatives) Because the creative types in client campaigns vary, the report should display client & typical results only for the creative types run. We are filtering by creative type in the card but would prefer to automate this - meaning have a responsive filtering mechanism that adjusts as creative types are added. Any thoughts on how to approach this in Beast Mode (or even ETL)?

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Coach
    Answer ✓

    Would something like this work?

    Case when SUM(SalesQuote) <> 0 and SUM(BannerAverage) <> 0 then 'Show' else 'Hide' end

Answers

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In