Medidor (mayor/menor a)

[Anonymous]

Hola! Tengo una tabla en que una de sus columnas es una evaluación correspondiente a un número entre 1,0 y 7,0 (similar a la siguiente tabla).

Fecha	Rol	Evaluación
03-05-2021	Administrador	6,8
17-06-2021	Operador	4,2
01-08-2021	Supervisor	5,4
...	...	...
09-02-2022	Operador	3,8

Estoy intentando hacer una visualización de tipo "Medidor" que muestre la cantidad de evaluaciones sobre y bajo 4,0, pero no lo he logrado. Por ejemplo, si tengo 14 evaluaciones y 10 de ellas son sobre 4,0 quiero que se muestre lo siguiente:

Muchas gracias!

[lbendlin]

What have you tried so far?

[Anonymous]

Almost everything, of course I'am missing something but I don't know what. I want to use a radial gauge that shows how many of the evalutions are under and over 4.0. Now I have 14 evaluations (numbers between 1.0 and 7.0), 10 of them are over 4.0, so the radial gauge should have a minumun value of 0, a maximun value of 14 (number of evaluations) and the blue area should be at 10 (number of evalutions over 4.0). I don't need to show any needle. Right know I have the minimun value set to 0, the maximun value as a count of the evaluations (in this case is 14, but it could change), and the field "value" empty. I tried to put the "evaluations" column at the "value" field with filters, but I didn't found any that do what I want. Do you know how to do that? Thanks!

[lbendlin]

the field "value" needs to contain the measure that computes to 10.

Please provide sample data that accurately describes what you want to achieve.

[Anonymous]

Yes, thanks. My problem is that I don't know how to put that mesure, what I mean is, I put the "evaluations" column in the "value" field and I can choose in the visualization if I want the sum, average, count... of the evaluations are shown (what is shown in the image below), but I have not been able to find the option to put a count of evaluations over 4.0. I attach a table with the data of the example mentioned in the previous comment (14 evaluations, 10 of them over 4.0).

Table with data

Fecha	Rol	Evaluación
15-04-2021	Administrador	4,1
24-04-2021	Supervisor	6,8
03-05-2021	Administrador	5,3
05-06-2021	Operador	3,8
17-07-2021	Operador	7,0
23-08-2021	Supervisor	2,4
11-10-2021	Administrador	6,2
30-10-2021	Operador	5,0
07-11-2021	Administrador	3,1
19-12-2021	Supervisor	5,6
27-21-2021	Administrador	6,2
03-01-2022	Operador	4,5
03-01-2022	Supervisor	1,9
06-02-2022	Operador	6,5

Fields

Filters of the "value" field

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Try this, create a slicer and a measure,

Measure = CALCULATE(COUNTROWS('Table'),ALLSELECTED('Table'))

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you!! That helps me