Count rows a slice has on the "main" view

[Rodrigo44]

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 · Accepted solution]

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] ) ,
  ...
)

[Marc_Dillon]

COUNT( slice[key-column] )

[Rodrigo44]

The thing is that I wanted a formula to create a virtual column with inside de "Calendário" table, that took the name of the slice in the [link] column.Where the blue numbers are the numbers of rows in each slice

[Marc_Dillon · Accepted solution]

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] ) ,
  ...
)

[Rodrigo44]

I've tried what you said:

Switch([link];
"Deadline_Atraso" ; COUNT(Deadline_Atraso[CodId]))

But for some reason it's returning this as an error:
"SWITCH function is used incorrectly: Inputs to SWITCH() must be an initial expression, one or more value-result pairs, and a default result"

Am I doing something wrong?

[Marc_Dillon]

https://help.appsheet.com/en/articles/2355972-switch

[Rodrigo44 · Accepted solution]

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!
 

[Abrownra]

Hey, could you possibly give me more insight on creating something like this? Haven't quite figured it out.