how to calculcate a field

[etxe]

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

[mpazbernal95-16]

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.