OBTENER PROMEDIO DE UNA COLUMNA EN TABLAS

Hola! Quisiera me brinden ayuda, quiero que en una celda me aparezca el promedio de unos datos registrados en una columna de un formulario en línea.

Ejemplo:

Tengo la columna "Cumplimiento total %" que sale automaticamente al responder un formulario, entonces quisiera que en esta misma tabla, aparezca en una celda el promedio de los valores de la columna "cumplimiento total%" para que este se actualice automaticamente y tambien crear un gráfico con este dato.

Hi agilescaasa,

Thanks for reaching out to Jotform Support. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

Now, let me help you with your question. You may add a new column with a formula for the calculation. Let me show you how you can create an Advanced Formula column in Jotform Tables:

1. In Table, add a new column.
2. Go to the Formula tab, select Advanced Formula, then click Next.
3. Enter a column name then click Next.
4. Create the formula using the editor.
5. When you’re done, click the Create Column button.

Give it a try and let us know how it goes.

Hola Hilary! Gracias por la respuesta, probé por la opción que me comentas pero me salía el promedio en todas las celdas de esa nueva columna, lo que yo requiero es que el promedio me salga en una (01) sóla celda.

Quedo atenta.

Hi agilescaasa,

Thanks for getting back to us. Unfortunately, our Spanish Support agents are busy helping other Jotform users at the moment. I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Spanish, let us know and we can have them do that. But, keep in mind that you'd have to wait until they're available again.

To confirm, you like to get the average of the column Cumplimiento %: and put it in the other column? Unfortunately, there's no way to do that since the column you'd like to calculate is already a Formula. We can calculate the average if the existing column is already set into your form and the data came from the submission.

If you want to learn more about this, you can check our detailed guide on how to use advanced formulas in jotform tables.

Reach out again if you have any other questions.