I created a bullet chart with multiple measures, and I am trying to label each measure with a benchmark value.
Each bar corresponds to today's value and the benchmark is yesterday's value. I want to label each bar with today's value, something like:
Cust Satisfaction (Today): AVG(if period = 'today' then [cust satisfaction] END)
Market Share (Today): AVG(if period = 'today' then [market share] END)
New Customers (Today): AVG(if period = 'today' then [new customers] END)
On Time Delivery (Today): AVG(if period = 'today' then [on time delivery] END)
Order Size (Today): AVG(if period = 'today' then [order size] END)
Profit (Today): AVG(if period = 'today' then [profit] END)
Revenue (Today): AVG(if period = 'today' then [revenue] END)
If I add these to the label, they will be repeated for each bar. Yesterday and today values come from the field named period.
I have attached a sample workbook. Essentially, I am trying to replicate Stephen Few's chart below.
HI Samuel,
Find my approach as reference below and stored in attached workbook version 10.1 located in the original thread.
My approach is explained here
Regards,
Norbert
