Count of stacked items in measure

Looker Q&A Looker
, , ,
1

Hi ,

I have a measure which shows values for each item in stack (when hover over) and sum of total stacks in Y axis.

Is there a way to count the number of stacks and display that number on the top?

2

Hi p_gill,

It is possible to get a version of this using table calculations:

In the above calculation, you would use the measure that is being stacked instead of

${order_items.total_gross_margin}

Then plot that number on a secondary axis:

Hope this helps,