how to calculcate a field

etxe
New Member

i need to know how many people comes from one country so i want do make a calculated fiel.

I need that data to later be able to calculate the percentage of visits from that country with respect to the percentage of total visits.

Im trying to do this:

COUNT(Vistas) where ID del país='ES'

But it doesn’t work. Is any way to calculate it?

Thankiu

0 1 117
1 REPLY 1

I believe that in your case you could use a filtered measure:

measure: vistas_es {
type: count
sql: ${vistas}
filters: [country: "ES"]
}

That way this measure will only show the visits coming from ES.

Top Labels in this Space
Top Solution Authors