Solved: Count rows a slice has on the "main" view - Page 2

Rodrigo44 · 02-17-2023 12:24 PM

Hi there,

I'm sure that is possible to count how many rows each slice has in this "main" view with some kind of formula in a virtual column, but I don't really know how to get there.

Marc_Dillon

Oh I get it. You can't dynamically refer to a table or slice name, so you'd have to do:

SWITCH( [column] ,
  "slice1" , COUNT( slice1[key] ) ,
  "slice2" , COUNT( slice2[key] ) ,
  ...
)

View solution in original post

Rodrigo44

Maybe I missunderstood the "..." at the end, but that link was very helpfull
I was missing the "default" part at the end of the formula, being the correct one:

SWITCH( [column] ,
  "slice1" , COUNT( slice1[key] ) ,
  "slice2" , COUNT( slice2[key] ) ,
  ... , 
  "")

Thank you so much for your help!

View solution in original post