Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hola estoy necesitando hacer una cuadro de estadisticas teniendo la siguiente informacion:
| id | leg | name | count(clientes) |
| 1 | 11 | jhon | 1000 |
| 2 | 22 | maria | 2000 |
| 3 | 22 | maria | 2000 |
| 4 | 11 | jhon | 1000 |
| 5 | 66 | marcos | 1000 |
Necesito obtener esto:
| Tabla de resultados | |
| value | total |
| 1000 | 3 |
| 2000 | 2 |
desde ya muchas gracias!!!
Just use Straight table and add dimension as Clientes and
expression Count(Clientes)
i need this table
| value | total |
| 1000 | 3 |
| 2000 | 2 |
Yes using straight table you can add dim as Value and
Count(Value) as your expression. Did you try?
Hi,
It is simple and try like this.
Value is a metric.
![]()
ok so what is the expr used ?
the exp used is COUNT (Sales)
sorry can you give us the original sample file to look into?