Gestione Risultati
From MedITEX - Wiki
Line 6: | Line 6: | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
− | <p> | + | <p>Dopo che una Query è stata eseguita, la finestra dei <strong>Risultati</strong> si aprirà.</p> |
<p> </p> | <p> </p> | ||
− | <h2> | + | <h2>Punsanti</h2> |
− | <p> | + | <p>Pulsanti con il controno tratteggiato blu hanno funzionalità speciali. Cliccarli per avere ulteriori informazioni.</p> |
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
<td><a href="/index.php?title=MedITEX_IVF_main_page"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/HomeRE.png" alt="" width="70" height="35" /></a></td> | <td><a href="/index.php?title=MedITEX_IVF_main_page"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/HomeRE.png" alt="" width="70" height="35" /></a></td> | ||
− | <td> | + | <td>Cliccando questo pulsante si passerà alla pagina principale di MedITEX.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/RefreshResult.png" alt="" width="85" height="35" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/RefreshResult.png" alt="" width="85" height="35" /></td> | ||
− | <td> | + | <td style="text-align: justify;">Se il valore relativo a uno o più campi della query è stato modificato, è possibile <strong>aggiornare</strong> i risultati premendo questo pulsante, senza eseguire di nuovo la query.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/UtilizeAs.png" alt="" width="75" height="35" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/UtilizeAs.png" alt="" width="75" height="35" /></td> | ||
− | <td> | + | <td>Con questo pulsante la query può essere impostata come lista o lettera in una delle sezione di MedITEX IVF.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/PrintRE.png" alt="" width="86" height="35" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/PrintRE.png" alt="" width="86" height="35" /></td> | ||
− | <td> | + | <td>Con questo pulsante sarà possibile stamapre la tabella dei risultati o una lettera (singola o seriale) in base a quale tab (Risultati Query, Modulo Word o Modulo Rich text) è attiva.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExportRE.png" alt="" /></td> | <td><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExportRE.png" alt="" /></td> | ||
− | <td> | + | <td>Con questo pulsante sarà possibile <strong>esportare</strong> la tabella dei risultati in file di diverso formato (Excel, CSV, HTML, TXT, PDF e XML).</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><a href="/index.php?title=Result_management#Administrate_letters"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/AdministrateLetters.png" alt="" width="109" height="35" /></a></td> | <td style="text-align: center;"><a href="/index.php?title=Result_management#Administrate_letters"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/AdministrateLetters.png" alt="" width="109" height="35" /></a></td> | ||
− | <td> | + | <td>Cliccando questo pulsante la finestra di <strong>Configurazione</strong> delle lettere si aprirà.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><a href="/index.php?title=Result_management#Statistical_analysis"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/Statistics.png" alt="" width="60" height="38" /></a></td> | <td style="text-align: center;"><a href="/index.php?title=Result_management#Statistical_analysis"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/Statistics.png" alt="" width="60" height="38" /></a></td> | ||
− | <td> | + | <td>Questo pulsante può essere utilizzato per<strong> generate grafici.</strong></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><img src="/images/Sum.png" alt="" /></td> | <td style="text-align: center;"><img src="/images/Sum.png" alt="" /></td> | ||
− | <td> | + | <td>La <strong>somma dei valori</strong> di una colonna verrà calcolata.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><img src="/images/Average.png" alt="" width="58" height="35" /></td> | <td style="text-align: center;"><img src="/images/Average.png" alt="" width="58" height="35" /></td> | ||
− | <td> | + | <td>La <strong>media dei valori </strong>di una colonna verrà calcolata.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><img src="/images/MinRE.png" alt="" width="32" height="35" /></td> | <td style="text-align: center;"><img src="/images/MinRE.png" alt="" width="32" height="35" /></td> | ||
− | <td> | + | <td>Il <strong>minimo valore</strong> di una colonna verrà visualizzato.</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td style="text-align: center;"><img src="/images/MaxRE.png" alt="" width="36" height="35" /></td> | <td style="text-align: center;"><img src="/images/MaxRE.png" alt="" width="36" height="35" /></td> | ||
− | <td> | + | <td>Il <strong>massimo valore</strong> di una colonna verrà visualizzato.</td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
− | <h2>Query | + | <h2>Risultati Query</h2> |
− | <p> | + | <p>Se la tab <strong>Risultati della Query</strong> è attiva,tutti i campi selezionati verranno elencati in colonne individiali. <strong>Ogni riga della tabella rappresenta un record.</strong></p> |
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
<tbody> | <tbody> | ||
Line 69: | Line 69: | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
− | <h3> | + | <h3>Filtrare, raggruppare o ordinare la lista dei risultati</h3> |
− | <p> | + | <p>La lista dei risultati può essere <strong>filtrata</strong>, <strong>raggruppata</strong> e <strong>ordinata</strong> agendo sull'intestazione delle colonne come spiegato <a href="/index.php?title=Welcome_to_MedITEX_IVF#Managing_Lists">qui</a><strong>.</strong> Il filtro corrisponde ad una restrizione logica del set di dati visualizzati nella sezione dei risultati (es. solamente pazienti incinte, etc.).</p> |
<p> </p> | <p> </p> | ||
− | <h3> | + | <h3>Analisi statistiche</h3> |
− | <p> | + | <p>I risultati della query possono essere utilizzati per creare<strong> analisi statistiche</strong>.</p> |
− | <p> | + | <p>Ci sono essenzialmente<strong> due modi </strong>di creare questo tipo di analisi:</p> |
<p> </p> | <p> </p> | ||
− | <h4> | + | <h4>Funzioni matematiche</h4> |
− | <p> | + | <p><strong>Funzioni matematiche di base</strong> possono essere applicate, coma la <strong>somma</strong>, <strong>media</strong>, <strong>minimo</strong> e <strong>massimo</strong> di una colonna, o <strong>generare un grafico</strong>.</p> |
<table border="0"> | <table border="0"> | ||
<tbody> | <tbody> | ||
Line 84: | Line 84: | ||
<td> | <td> | ||
<ul> | <ul> | ||
− | <li> | + | <li>Se si clicca <img src="/images/Sum.png" alt="" /> , la <strong>somma dei valori </strong>nella colonna in cui si trova il valore selezionato (numbero 8, cerchiato di rosso) sarà <strong>visualizzata sul fondo</strong> della colonna.</li> |
</ul> | </ul> | ||
<ul> | <ul> | ||
− | <li> | + | <li>Se si clicca <img src="/images/Average.png" alt="" width="58" height="35" /><strong> </strong>, la <strong>media dei valori </strong>nella colonna in cui si trova il valore selezionato, sarà <strong>visualizzata sul fondo</strong> della colonna.</li> |
</ul> | </ul> | ||
<ul> | <ul> | ||
− | <li> | + | <li>Se si clicca <img src="/images/MinRE.png" alt="" width="32" height="35" /> o <img src="/images/MaxRE.png" alt="" width="36" height="35" />, il valore minimo (nel nostro esempio 0) o il valore massimo (nel nostro esempio 9) sarà <strong>visualizzato sul fondo</strong> della colonna. </li> |
</ul> | </ul> | ||
</td> | </td> | ||
Line 97: | Line 97: | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
− | <h4> | + | <h4>Generare un grafico</h4> |
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
<td><img src="/images/Statistics.png" alt="" width="60" height="38" /></td> | <td><img src="/images/Statistics.png" alt="" width="60" height="38" /></td> | ||
− | <td> | + | <td>Se si clicca il tasto <strong>Statistiche</strong>, la finestra qui sotto verrà aperta:</td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
Line 116: | Line 116: | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
− | <p> | + | <p>L' <strong>asse X</strong> può essere qualsiasi colonna della tabella dei risultati.</p> |
− | <p> | + | <p>L' <strong>asse Y </strong>potrà essere generata solamente da colonne contenenti solamente numeri (numeri interi o decimali).</p> |
<p>These are only <strong>descriptive statistics</strong>: histograms, plots and their individual parts.</p> | <p>These are only <strong>descriptive statistics</strong>: histograms, plots and their individual parts.</p> | ||
<p>The <strong>interpretation </strong>of the<strong> y-axis values</strong> exclusively depends on the <strong>scale measurement</strong> of the data used (the data is, however, displayed in such a way as if the values were all interval-scaled).</p> | <p>The <strong>interpretation </strong>of the<strong> y-axis values</strong> exclusively depends on the <strong>scale measurement</strong> of the data used (the data is, however, displayed in such a way as if the values were all interval-scaled).</p> |
Latest revision as of 16:48, 15 April 2016
Dopo che una Query è stata eseguita, la finestra dei Risultati si aprirà.
Contents |
Punsanti
Pulsanti con il controno tratteggiato blu hanno funzionalità speciali. Cliccarli per avere ulteriori informazioni.
<a href="/index.php?title=MedITEX_IVF_main_page"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/HomeRE.png" alt="" width="70" height="35" /></a> | Cliccando questo pulsante si passerà alla pagina principale di MedITEX. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/RefreshResult.png" alt="" width="85" height="35" /> | Se il valore relativo a uno o più campi della query è stato modificato, è possibile aggiornare i risultati premendo questo pulsante, senza eseguire di nuovo la query. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/UtilizeAs.png" alt="" width="75" height="35" /> | Con questo pulsante la query può essere impostata come lista o lettera in una delle sezione di MedITEX IVF. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/PrintRE.png" alt="" width="86" height="35" /> | Con questo pulsante sarà possibile stamapre la tabella dei risultati o una lettera (singola o seriale) in base a quale tab (Risultati Query, Modulo Word o Modulo Rich text) è attiva. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/ExportRE.png" alt="" /> | Con questo pulsante sarà possibile esportare la tabella dei risultati in file di diverso formato (Excel, CSV, HTML, TXT, PDF e XML). |
<a href="/index.php?title=Result_management#Administrate_letters"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/AdministrateLetters.png" alt="" width="109" height="35" /></a> | Cliccando questo pulsante la finestra di Configurazione delle lettere si aprirà. |
<a href="/index.php?title=Result_management#Statistical_analysis"><img style="display: block; margin-left: auto; margin-right: auto; border: 2px dotted blue;" src="/images/Statistics.png" alt="" width="60" height="38" /></a> | Questo pulsante può essere utilizzato per generate grafici. |
<img src="/images/Sum.png" alt="" /> | La somma dei valori di una colonna verrà calcolata. |
<img src="/images/Average.png" alt="" width="58" height="35" /> | La media dei valori di una colonna verrà calcolata. |
<img src="/images/MinRE.png" alt="" width="32" height="35" /> | Il minimo valore di una colonna verrà visualizzato. |
<img src="/images/MaxRE.png" alt="" width="36" height="35" /> | Il massimo valore di una colonna verrà visualizzato. |
Risultati Query
Se la tab Risultati della Query è attiva,tutti i campi selezionati verranno elencati in colonne individiali. Ogni riga della tabella rappresenta un record.
Filtrare, raggruppare o ordinare la lista dei risultati
La lista dei risultati può essere filtrata, raggruppata e ordinata agendo sull'intestazione delle colonne come spiegato <a href="/index.php?title=Welcome_to_MedITEX_IVF#Managing_Lists">qui</a>. Il filtro corrisponde ad una restrizione logica del set di dati visualizzati nella sezione dei risultati (es. solamente pazienti incinte, etc.).
Analisi statistiche
I risultati della query possono essere utilizzati per creare analisi statistiche.
Ci sono essenzialmente due modi di creare questo tipo di analisi:
Funzioni matematiche
Funzioni matematiche di base possono essere applicate, coma la somma, media, minimo e massimo di una colonna, o generare un grafico.
<img src="/images/MathRE.png" alt="" /> |
|
Generare un grafico
<img src="/images/Statistics.png" alt="" width="60" height="38" /> | Se si clicca il tasto Statistiche, la finestra qui sotto verrà aperta: |
L' asse X può essere qualsiasi colonna della tabella dei risultati.
L' asse Y potrà essere generata solamente da colonne contenenti solamente numeri (numeri interi o decimali).
These are only descriptive statistics: histograms, plots and their individual parts.
The interpretation of the y-axis values exclusively depends on the scale measurement of the data used (the data is, however, displayed in such a way as if the values were all interval-scaled).
Explanation of the fields/icons: | |
Curve, Bars... Pareto | These are different layouts that can be chosen for the chart. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/2D3D.png" alt="" width="59" height="28" /> | By clicking on these buttons, the chart will have a 2D/3D layout. |
<img src="/images/0,00.png" alt="" /> |
This button sets the decimal places. |
<img src="/images/BE.png" alt="" width="43" height="27" /> | Displays basis unit or unit. |
<img src="/images/Colours.png" alt="" width="59" height="25" /> |
Changes background colours of the graph and of the form. A third option allows the swapping the colours between the graph and the form. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Legend.png" alt="" width="57" height="25" /> | Click on this button to show/hide the legend. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Toolbar.png" alt="" width="59" height="27" /> | Click on this button to show/hide the toolbar. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/PlusChart.png" alt="" width="54" height="29" /> | Creates a new chart. It will be opened at the right side of the window. Close it with the red X button. |
Parameter | Changes the Parameters shown in the chart. |
Time period | Sets a period. |
<img src="/images/Ed.png" alt="" /> | Click on this button to edit the chart title. |
<img src="/images/ed1.png" alt="" width="24" height="22" /> | Click on this button to edit the font and colour of titles and legend. |
<img src="/images/ed2.png" alt="" width="24" height="22" /> | Click on this icon to hide/show pattern bar, palette bar and legend. By clicking on this button it is also possible to access to the data editor. |
<img src="/images/ed3.png" alt="" width="24" height="22" /> | Click on this button to modify the view options. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/Graph.png" alt="" width="85" height="26" /> |
By clicking this button the user can:
|
<img src="/images/hint48.png" alt="" width="48" height="48" /> |
If your system does not give support to the necessary library, a much simpler version of this tool will be presented. It is also possible to switch between modes clicking on the button Graph and choosing Exchange chart type. |
Word module
By selecting the word module tab a simple list will be shown.
Explanation of columns
Placeholder |
This column displays the placeholders present in the query. Each placeholder has been generated by the selection of one field during the query building. A placeholder can be duplicated just double clicking on it. If the same field is needed more than once in the letter, just duplicate the placeholder. The new placeholder will be filled with the same value of the parent placeholder. |
Utilize | Here the user can choose if the value related to a placeholder will be shown in the letter. To change the status from Yes to No just double-click on the corresponding cell. |
Bookmark | This column displays the names of the bookmarks present in the Word file related to the query. To edit the name of the bookmark just double-click it. |
Value |
This column displays the results related to a given placeholder for the selected record. |
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/REButtons.png" alt="" /> |
With these buttons, it is possible to swap back and forth from one record to another, changing the values of the results accordingly. |
<img src="/images/AdPlace.png" alt="" /> |
Using additional placeholders: In addition to the placeholders selected while building the query, new placeholders can be used. The additional placeholders allow the user to add to the letter: ultrasound and embryo images, user signatures, date and time specifications. To add a placeholder press this button. When a placeholder is selected it will appear in the list along with its bookmark and it can be used in the letter just like other placeholders. |
Creating a letter
When the query is saved for the first time, a Word file is created in the folder WOMOD. This folder is in File_Storage\Templates. The complete path can be seen in the <a href="/index.php?title=MedITEX_IVF_Settings#General">settings</a>.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/CreateCust.png" alt="" /> |
When this button is clicked the standard WOMOD template opens. The template will contains all the bookmarks listed in the Bookmarks column with the related placeholder. |
If a model of the letter is available as a MS Word document, it is possible to save such model as a template before building the query. The template must be saved in the WOMOD folder and shall have the same name that the query will have. |
To create a letter:
1. Write down the standard text. |
2. Cut and paste placeholders in the appropriate position. Once a placeholder is allocated, it can be deleted from the list at the bottom of the page. |
3. Once all placeholders are positioned and deleted at the bottom list, the letter can be saved. |
<img src="/images/ed4.png" alt="" width="147" height="102" /> | Saved letters may be edited by clicking Edit template. |
<img src="/images/ed5.png" alt="" /> | To view and print the letter related to the selected record, press Generate letter. A letter with all filled placeholders will open: |
Using letters as standard templates
Once a letter is created, you may want to set it as a standard template.
What matters here is the combination of the group elements for your query.
If your query contains a reference to: |
|
|
|
Press the black arrow on the right of the button Utilize as, select Letter templates and assign the document to one of the available entries.
For our example, only two options will be available:
<img src="/images/Letter6.png" alt="" /> |
In the main window of MedITEX IVF you can now click the menu-item Letters and see (depending on the currently opened input mask) exactly those queries whose letter templates you have linked (assume we have chosen for our query Cycle letter, the letter will be available in the cycle input mask).
A click on the desired entry in the menu leads to the execution of the query for the current patient or the current therapy only.
A Word document is then generated from the associated letter template. The word document will automatically be copied in the file storage folder related to the patient and the document entry in the patient demographics mask will also be generated. The type of the document generated in the demographics will be the one assigned as described <a href="/index.php?title=Result_management#Administrate_letters">here</a>.
Printing letters
In order to print the created letters from MedITEX IVF, you must be in the appropriate window. For example, if you wish to print a Medical history letter, you must first select the desired patient, then click on Medical history and finally, generate the letter from the top menu Letter.
<a href="/index.php?title=How_to_print_letters%3F"><img src="/images/howto48.png" alt="" width="48" height="48" /></a> | <a href="/index.php?title=How_to_print_letters%3F">Click here</a> to read more about printing letters |
Serial letters
Report editor also allows the printing of serial letters. In order to perform this task, select several rows from the Results tab, change to the WOMOD tab and click on Print-> Serial letters. The letters will be saved in the File storage for each patient where the letter was created and after, printed.
<a href="/index.php?title=How_to_print_letters%3F#Serial_letters"><img src="/images/howto48.png" alt="" width="48" height="48" /></a> | <a href="/index.php?title=How_to_print_letters%3F#Serial_letters">Click here</a> to read more about printing serial letters. |
Rich text module
The Rich text module tool allows the easy creation of letters and documents. A document is composed of three units: header, text area and footer.
- The header, for example, you can add a logo, individual text and the date.
- In the text area you can add individual text which ideally contains placeholders (text contained between two %%; eg %Persons.First name%) of the result table. As you can see in the print preview, these placeholders will be replaced by the values of the result table. Placeholders can be duplicated selecting them from the drop box Placeholders and clicking on <img src="/images/RichB.png" alt="" />. Moreover, additional placeholders can be used.
- The footer may contain a greeting, address or a name.
Standard formatting (font size, text alignment, color etc.) can be applied in all three areas.
Header and footer can be saved and imported later for other documents.
<img src="/images/OpenTemp.png" alt="" width="143" height="21" /> | To import header and footer from another document, select the document to import from and press Open template. |
Administrate letters
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/AdministrateLSettings.png" alt="" width="190" height="31" /> | <a href="/index.php?title=Result_management#Administrate_letters"><img style="display: block; margin-left: auto; margin-right: auto;" src="/images/AdministrateLetters.png" alt="" width="109" height="35" /></a> |
You can find this button in the <a href="/index.php?title=MedITEX_IVF_Settings#Report_editor">settings</a>. |
You can find this button in the result management of the <a href="/index.php?title=Result_management#Buttons">report editor</a>. |
If one of these buttons are clicked the following window opens: |
<a href="/index.php?title=Configure_letters"><img src="/images/plus48.png" alt="" width="48" height="48" /></a> | <a href="/index.php?title=Configure_letters">Click here</a> to have more information about the content of this window. |
The list on the left shows the letters which have been set to be available in one of the MedITEX sections. If the user selects the type of document in the Document type drop menu, the letter will be saved in the demographic section among the documents of the same type.
<img style="display: block; margin-left: auto; margin-right: auto;" src="/images/AdEdDelRE.png" alt="" width="97" height="30" /> |
Other types of documents may be created clicking on Plus. Once a type of document is created it will be available in the New entry menu present in the Demographics section. With the button Edit, the document type can be edited. A letter can be removed from the MedITEX section it was assigned to by selecting it and clicking on Delete. |
<img src="/images/Always.png" alt="" /> | Enabling memory query. |
The box under Show placeholder / Show SQL-Query is useful for support purposes. |
<a href="/index.php?title=MedITEX_IVF_manual">Back to the MedITEX IVF menu </a> | <a href="#top">Back to top</a> |
<a href="/index.php?title=Configure_letters"><img src="/images/help.png" border="1" alt="" width="48" height="48" align="BOTTOM" /> </a><a href="/index.php?title=Configure_letters">Click here</a> to have more information about the content of this window. |