Diferencia entre revisiones de «Reports/en»

De wiki.kiconex
(Página creada con «=== Report creation === By accessing the [https://{{SERVERNAME}}/index.php/Special:myLanguage/Facilities facility], it access the reports: {| class="wikitable sortable" |centro|miniatureimage|450x450px |centro|miniatureimage|450x450px |} From this section, there are two tabs: one to list each type of report. Turther to the right is the "+" ico…»)
Sin resumen de edición
 
(No se muestran 3 ediciones intermedias de 2 usuarios)
Línea 2: Línea 2:
Reports are one of mykiConex tool that allows to export data from connected devices. Currently, there are two types of reports:
Reports are one of mykiConex tool that allows to export data from connected devices. Currently, there are two types of reports:


* '''Data export''': enabled exclusively in facilities with [https://www.kiconex.com/tarifa/ PROFESSIONAL or PREMIUM plan]. Allows to export in Excel file the historical data of the desired variables, being able to select a start and end date of the data to be downloaded, as well as a time interval between data and downloaded data.
* '''Data export''': enabled exclusively in facilities with PROFESSIONAL or PREMIUM plan. Allows to export in Excel file the historical data of the desired variables, being able to select a start and end date of the data to be downloaded, as well as a time interval between data and downloaded data.
* '''Statistical report''': enabled exclusively in facilities with [https://www.kiconex.com/tarifa/ PREMIUM plan]. It performs a very simple statistical analysis of the selected variables:
* '''Statistical report''': enabled exclusively in facilities with PREMIUM plan. It performs a very simple statistical analysis of the selected variables:
** For analog variables: maximum, minimum and average.
** For analog variables: maximum, minimum and average.
** For digital variables: percentage of active and inactive times, number of active times.
** For digital variables: percentage of active and inactive times, number of active times.
Línea 17: Línea 17:
By accessing the [https://{{SERVERNAME}}/index.php/Special:myLanguage/Facilities facility], it access the reports:
By accessing the [https://{{SERVERNAME}}/index.php/Special:myLanguage/Facilities facility], it access the reports:
{| class="wikitable sortable"
{| class="wikitable sortable"
|[[Archivo:SP botón de informes en la instalación 1.png|centro|miniatureimage|450x450px]]
|[[Archivo:SP botón de informes en la instalación 1.png|centro|miniatureimage|800x800px]]
|[[Archivo:SP Pestaña de informes dentro de la instalación 2.png|centro|miniatureimage|450x450px]]
|[[Archivo:SP Pestaña de informes dentro de la instalación 2.png|centro|miniatureimage|800x800px]]
|}
|}
From this section, there are two tabs: one to list each type of report. Turther to the right is the "+" icon to create a new report.
From this section, there are two tabs: one to list each type of report. Turther to the right is the "+" icon to create a new report.
Línea 24: Línea 24:




<div lang="es" dir="ltr" class="mw-content-ltr">
Clicking on the creation icon takes you to a window with three configuration tabs:
Al hacer clic en el icono de creación, se accede a una ventana en la que hay tres pestañas de configuración:
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
* '''GENERAL''': name and description for the report.
* '''GENERAL''': nombre y descripción para el informe
* '''Report configuration''': an interval between each variable data is established. Besides being able to add these variables from the "+" icon, to the right of ''Current series''.
* '''CONFIGURACIÓN DEL INFORME''': se establece un intervalo entre cada dato de las variables, además de poder añadir dichas variables desde el icono +, a la derecha de "Series actuales".
* '''PERMISSIONS''': tab allowed to give permissions to another user to view the created report. By default, the report can only be viewed by the user who created it.
* '''PERMISOS''': pestaña donde se puede dar permisos a otro usuario para que vea el informe creado. Por defecto, el informe solo puede verlo el usuario que lo crea.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
[[Archivo:SP Pestaña general informe.png|centro|miniatureimage|800x800px|'''General tab''' of report configuration, allows to set '''name''' and '''description'''.]]
[[Archivo:SP Pestaña general informe.png|centro|miniaturadeimagen|800x800px|'''Pestaña general''' de configuración del informe, permite establecer '''nombre''' y '''descripción'''.]]
[[Archivo:SP Pestaña configuración informe.png|centro|miniatureimage|800x800px|'''Report configuration tab''', where '''interval''' between each data is set and '''desired variables''' are added.]]
[[Archivo:SP Pestaña configuración informe.png|centro|miniaturadeimagen|800x800px|'''Pestaña de configuración del informe''', donde se establece '''intervalo''' entre cada dato y se añaden las '''variables deseadas'''.]]
</div>




<div lang="es" dir="ltr" class="mw-content-ltr">
To add variables to the report, click on the "+" icon, which opens the following window:
Para añadir variables al informe, se hace clic sobre el símbolo +, que abre la siguiente ventana:
[[Archivo:SP adición variables a informe.png|centro|miniaturadeimagen|600x600px|Window for adding '''variables''', specifying the '''control''' and the '''facility''' in which they are located.]]
[[Archivo:SP adición variables a informe.png|centro|miniaturadeimagen|600x600px|Ventana de adición de '''variables''', especificando el '''control''' y la '''instalación''' en la que se encuentran.]]
</div>




<div lang="es" dir="ltr" class="mw-content-ltr">
In this window, one or several variables of interest can be selected.
En dicha ventana se puede seleccionar una o varias variables de interés.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
=== Editing the report ===
=== Edición del informe ===
The report can be edited from two places: by right mouse clicking on it and selecting the '''edit''' option. As shown in these images:
El informe puede ser editado desde 2 sitios, haciendo clic derecho sobre el mismo y seleccionando la opción '''editar'''. Como muestran estas imágenes:
[[Archivo:Editar informe en instalacion.png|centro|miniatureimage|800x800px|Editing a report, from the corresponding section within the installation.]]
[[Archivo:Editar informe en instalacion.png|centro|miniaturadeimagen|800x800px|Edición de un informe, desde la sección correspondiente dentro de la instalación]]
[[Archivo:Editar informe desde lista del menú lateral.png|centro|miniaturadeimagen|800x800px|Editing a report from the list obtained in the side report menu.]]
[[Archivo:Editar informe desde lista del menú lateral.png|centro|miniaturadeimagen|800x800px|Edición de un informe desde la lista obtenida en el menú de informes lateral.]]
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
=== Downloading the report ===
=== Descarga del informe ===
Before downloading the report, it is necessary to confirm the start and end date of the data to be downloaded, as well as the time interval between each data point. The following image shows each of the points of the report:
Antes de descargar el informe, es necesario confirmar la fecha de comienzo y de fin de los datos que se descargarán, así como el intervalo de tiempo entre cada dato. La siguiente imagen recoge cada uno de los puntos del informe:
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
# '''Start and end date''' of the data to be processed. In the example image below a week of data has been selected. Shown right is the time zone with which the data will be downloaded, for more information you can consult the configuration of the [https://{{SERVERNAME}}/index.php/Special:myLanguage/Facilities/en facility] or of the [https://{{SERVERNAME}}/index.php/Special:myLanguage/UserProfile/en user profile].
# '''Fecha de comienzo y de fin''' de los datos a tratar. En la imagen de ejemplo siguiente se ha seleccionado una semana de datos. Se muestra la derecha la zona horaria con la que se descargarán los datos, para más información puede consultar la configuración de la [https://{{SERVERNAME}}/index.php/Special:myLanguage/Facilities instalación] o del [https://{{SERVERNAME}}/index.php/Special:myLanguage/UserProfile perfil de usuario].
# '''Interval''': Time between each data. It has a minimum value that depends on the configuration of the variables of the [https://{{SERVERNAME}}/index.php/Special:myLanguage/Controls/en control]. By default, it is usual to use a 60 sec interval for most connected controls.
# '''Intervalo''': Tiempo entre cada dato. Tiene un valor mínimo que depende de la configuración de las variables del [https://{{SERVERNAME}}/index.php/Special:myLanguage/Controls control]. Por defecto, es habitual el uso de un intervalo de 60 seg. en la mayoría de controles conectados.
# '''Type''': indicates the type of report to be downloaded.
# '''Tipo''': indica el tipo de informe que se descargará.
# '''List of the variables''' involved in the report, showing information on the facility and the control to which they belong.
# '''Lista las variables''' implicadas en el informe, mostrando información de la instalación y el control al que pertenecen.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
[[Archivo:SP Partes del informe.png|centro|miniaturadeimagen|800x800px|Report sections]]
[[Archivo:SP Partes del informe.png|centro|miniaturadeimagen|800x800px|Partes de un informe]]
</div>




<div lang="es" dir="ltr" class="mw-content-ltr">
To download the report, just click on the arrow symbol next to the magnifying glass, as shown in the image below:
Para la descarga del informe, solo hay que hacer clic en el símbolo con la flecha que hay junto a la lupa, como se muestra en la imagen a continuación:
[[File:SP exportar informe.png|center|miniatureimage|800x800px|Download or export report]]The download will take time depending on the amount of data requested. For instance: if months of data are requested, the query will take longer and therefore the user will wait longer until the report is downloaded.
[[Archivo:SP exportar informe.png|centro|miniaturadeimagen|800x800px|Descarga o exportación del informe]]La descarga tardará más o menos en función de la cantidad de datos solicitados. Por ejemplo, si se solicitan meses de datos, la consulta tardará más y, por lo tanto, el usuario debe esperar más hasta que se descarga el informe.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
=== Interpretation of a data export report ===
=== Interpretación de un informe de exportación de datos ===
The result of downloading a data export report, is an excel with the appearance of the following image:
El resultado de descargar un informe de exportación de datos, es un excel con el aspecto de la siguiente imagen:
[[File:SP Aspecto informe datos.png|center|miniatureimage|800x800px|Example data export with analog and digital variables]]
[[Archivo:SP Aspecto informe datos.png|centro|miniaturadeimagen|800x800px|Ejemplo de exportación de datos con variables analógicas y digitales]]
</div>




<div lang="es" dir="ltr" class="mw-content-ltr">
The information shown is as follows:
La información mostrada es la siguiente:
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
* '''Organization's logo'''' in the header
* '''Logo''' de la organización en la cabecera
* 5 lines for each variable, where it is indicated:
* 5 líneas para cada variable, donde se indica:
** '''Facility''' of origin of the variable
** '''Instalación''' de procedencia de la variable
** '''Control''' to which the variable belongs
** '''Control''' al que pertenece dicha variable
** '''Name'''
** '''Nombre'''
** '''Unit''' of measure
** '''Unidad''' de medida
** '''Type''. How the platform interprets that variable: analog or digital
** '''Tipo''': Cómo la plataforma interpreta esa variable: analógica o digital
* One line for each data recorded for each variable. The '''first column shows the date and time''' of data recording and in the column of each variable the corresponding value.
* Una línea para cada dato registrado de cada variable. En la '''primera columna se muestra la fecha y hora''' de registro del dato y en la columna de cada variable el valor correspondiente.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
=== Interpretation of a statistical report ===
=== Interpretación de un informe estadístico ===
The result of downloading a statistical report, is an excel with the appearance of the following image:
El resultado de descargar un informe estadístico, es un excel con el aspecto de la siguiente imagen:
[[File:SP Aspecto informe estadístico.png|center|miniatureimage|729x729px|Example statistical report export]]
[[Archivo:SP Aspecto informe estadístico.png|centro|miniaturadeimagen|729x729px|Ejemplo de exportación de informe estadístico]]
The information displayed is as follows:
La información mostrada es la siguiente:
* '''Logo''' of the organization in the header.
* '''Logo''' de la organización en la cabecera
* '''User''' who has downloaded the report.
* '''Usuario''' qua ha descargado el informe
* Time data:
* Datos de tiempo:
** '''Start date''' of the analyzed data
** '''Fecha de comienzo''' de los datos analizados
** '''End date''' of the data
** '''Fecha de fin''' de los datos
** '''Interval''' or time between each data involved in the analysis.
** '''Intervalo''' o tiempo entre cada dato implicado en el análisis.
* '''Name''' and '''description''' of the '''facility''' to which the variables belong.
* '''Nombre''' y '''descripción''' de la '''instalación''' a la que pertenecen las variables.
* '''Name''' and '''description''' of the '''control''' containing the variables.
* '''Nombre''' y '''descripción''' del '''control''' que contiene dichas variables.
* Analysis of analog variables, with the data: maximum, minimum and average.
* Análisis de variables analógicas, con los datos: máximo, mínimo y media
* Analysis of digital variables: indicates % on and % off, as well as a count of the number of activations the variable has undergone.
* Análisis de variables digitales: indica % de endendidos y % de apagados, así como un contaje de la cantidad de activaciones que sufre la variable.
</div>


<div lang="es" dir="ltr" class="mw-content-ltr">
As can be seen, a data sheet is created for each control involved, so that performance comparisons can be made for controls of the same model.
Como se puede ver, se crea una hoja de datos para cada control implicado, así se pueden hacer comparativas de funcionamiento para controles de un mismo modelo.
</div>

Revisión actual - 07:09 10 abr 2024

Reports

Reports are one of mykiConex tool that allows to export data from connected devices. Currently, there are two types of reports:

  • Data export: enabled exclusively in facilities with PROFESSIONAL or PREMIUM plan. Allows to export in Excel file the historical data of the desired variables, being able to select a start and end date of the data to be downloaded, as well as a time interval between data and downloaded data.
  • Statistical report: enabled exclusively in facilities with PREMIUM plan. It performs a very simple statistical analysis of the selected variables:
    • For analog variables: maximum, minimum and average.
    • For digital variables: percentage of active and inactive times, number of active times.


Reports can be created from the corresponding section within instalación.

From the left side menu, all the reports created in any of the facilities are shown.

Reports menu. Displays all created reports.
Reports menu. Displays all created reports.

Report creation

By accessing the facility, it access the reports:

miniatureimage
miniatureimage
miniatureimage
miniatureimage

From this section, there are two tabs: one to list each type of report. Turther to the right is the "+" icon to create a new report.

miniatureimage
miniatureimage


Clicking on the creation icon takes you to a window with three configuration tabs:

  • GENERAL: name and description for the report.
  • Report configuration: an interval between each variable data is established. Besides being able to add these variables from the "+" icon, to the right of Current series.
  • PERMISSIONS: tab allowed to give permissions to another user to view the created report. By default, the report can only be viewed by the user who created it.
General tab of report configuration, allows to set name and description.
General tab of report configuration, allows to set name and description.
Report configuration tab, where interval between each data is set and desired variables are added.
Report configuration tab, where interval between each data is set and desired variables are added.


To add variables to the report, click on the "+" icon, which opens the following window:

Window for adding variables, specifying the control and the facility in which they are located.


In this window, one or several variables of interest can be selected.

Editing the report

The report can be edited from two places: by right mouse clicking on it and selecting the edit option. As shown in these images:

Editing a report, from the corresponding section within the installation.
Editing a report, from the corresponding section within the installation.
Editing a report from the list obtained in the side report menu.

Downloading the report

Before downloading the report, it is necessary to confirm the start and end date of the data to be downloaded, as well as the time interval between each data point. The following image shows each of the points of the report:

  1. Start and end date of the data to be processed. In the example image below a week of data has been selected. Shown right is the time zone with which the data will be downloaded, for more information you can consult the configuration of the facility or of the user profile.
  2. Interval: Time between each data. It has a minimum value that depends on the configuration of the variables of the control. By default, it is usual to use a 60 sec interval for most connected controls.
  3. Type: indicates the type of report to be downloaded.
  4. List of the variables involved in the report, showing information on the facility and the control to which they belong.
Report sections


To download the report, just click on the arrow symbol next to the magnifying glass, as shown in the image below:

Download or export report
Download or export report

The download will take time depending on the amount of data requested. For instance: if months of data are requested, the query will take longer and therefore the user will wait longer until the report is downloaded.

Interpretation of a data export report

The result of downloading a data export report, is an excel with the appearance of the following image:

Example data export with analog and digital variables
Example data export with analog and digital variables


The information shown is as follows:

  • Organization's logo' in the header
  • 5 lines for each variable, where it is indicated:
    • Facility of origin of the variable
    • Control to which the variable belongs
    • Name
    • Unit of measure
    • 'Type. How the platform interprets that variable: analog or digital
  • One line for each data recorded for each variable. The first column shows the date and time of data recording and in the column of each variable the corresponding value.

Interpretation of a statistical report

The result of downloading a statistical report, is an excel with the appearance of the following image:

Example statistical report export
Example statistical report export

The information displayed is as follows:

  • Logo of the organization in the header.
  • User who has downloaded the report.
  • Time data:
    • Start date of the analyzed data
    • End date of the data
    • Interval or time between each data involved in the analysis.
  • Name and description of the facility to which the variables belong.
  • Name and description of the control containing the variables.
  • Analysis of analog variables, with the data: maximum, minimum and average.
  • Analysis of digital variables: indicates % on and % off, as well as a count of the number of activations the variable has undergone.

As can be seen, a data sheet is created for each control involved, so that performance comparisons can be made for controls of the same model.