StarLogin 8

Statistics and reports

The Statistics and reports button of the main window opens the following window:











A : access to data processing and complex searches.
B : access to predefined reports.

Data processing











  • A: a tab accessible at the opening. If reporting templates have already been saved, which is not the case when you first launch StarLogin 8, the name of the corresponding reports is included in the list D.
  • B: tab with tables whose data can be analyzed.
  • C: The other tabs are not available at the opening.
  • D: List of reports already saved.
  • E: detailed data of the selected report. Here no report is selected.










  • A: list of tables that can be analyzed.
  • B: selected table.
  • C: data corresponding to the selected table if it is not empty.

When a report is selected in the first tab or a table selected in the second one, the third tab becomes available:











  • A: list of information fields (or columns) of the selected table.
  • B button to select all the fields, so that all possible columns appear in the grid.
  • C: to deselect all fields.
    If no field is selected and the selection is valid in D, no data will be seen later, even if the table is not empty. Therefore maintain at least a visible column for further process analysis or research.
  • D: button to select the fields and go to the next step:










  • A: Boolean operator And or Or to combine simple filters into more complex queries.
  • B: opening parentheses in the case of complex filters (using And and Or).
  • C: information field (or grid column) on which to build a filter or search criteria (eg Type of entity in the event table).
  • D: comparison operator to build the filter combining C, D and E.
  • E: expected value. For example, if you select Place latitude in C, Greater than in D, and write " 20°" in E (with a space character before 20, because of the field format), the search criteria or filter is: Place latitude Greater than  20°. By clicking on the button I, the validation of the built filter then restricts the grid events to the only ones for which the Place latitude is greater than 20 degrees (and so are northern ones). From the image above, the event in line 15 would not be kept since the latitude is only 14 degrees.
  • F: closing parentheses in the case of complex filters.
  • G: button to validate the simple filter and add it to other simple filters already combined (if any, of course) in order to build a more complex filter. The plain text of the resulting filter appears in the Filter box, between the buttons G, H, I and the data grid.
  • H: button to clear the filter (especially in case of error while developing a complex filter).
  • I: button to validate the simple or complex built filter and proceed to the next step:










  • A: information field on which to sort the grid.
  • B: mention of ascending or descending sort.
  • C: button to validate the sorting and move to the next step.

Note that you can directly proceed to the next step without specifying sort (as you can bypass each of the previous steps).











  • A: select or not a grouping operation for a given field of information. Here we have selected Number for the Index field in the table (which is used to number the lines and therefore to count the events ) and Group for the Entity type field. Group means that we somehow combines all records by Entity type in this case. And counting the Index is like counting how many events are by entity type.
  • B: optional filter on the information field. Here we could specify that the index field must be greater than 100 (value written in C) and this would eliminate part of the events.
  • C: expected value for the operation in B on the considered A field.
  • D: button to validate the grouping operation and proceed to the next step (you can go to the next step without setting those operations):










  • A : button to display the report in an HTML editor and change if needed:


    A
    Saving the report in HTML format (then viewable with Internet explorer).
    B
    Printing the report.
    C
    Copy the selected text from the document.
    D
    Cut the selected text from the document.
    E
    Paste the contents of the clipboard at the cursor position in the document.
    F
    Insert an image.
    G
    Insert table.
    H
    Change the color of selected text.
    I
    Make the selected text bold.
    J
    Make the selected text italic.
    K
    Change the font of the selected text.
    L
    Change the font size of the selected text.
    M
    Left align the selected text.
    N
    Center the selected text.
    O
    Right align the selected text.
    P
    Add bullets to the lines of selected text.
    Q
    Indent the selected text to the left.
    R
    Right indent the selected text.
    S
    Indent the first line of the selected text.
    T
    Add a space before the selected text.
    U
    Add a space after the selected text.
    V
    Increase spacing.
    W
    Undo the changes.
    X
    Redo the changes.
    Y
    Search the Z text in the document.
    Z
    Text to search in the document

  • B button to save the report template and then find it in the list on the first tab (Saved models of reports).
  • C: button to reset the grid and start from the first step.
  • D: grid resulting from the above step. In the example we had made a query to count the number of events (number of Index) by type of entity and the grid shows the result. There are 338 such events related to humans.

Reports











Selecting a report from the list opens a corresponding window to the select criteria in order to filter the data in question:











  • A : selected report.
  • B : list of reports.
  • C: minimum Date of birth for contacts to keep. A click on the entry field shows the schedule M visible on the right.
  • D: maximum Date of birth. Clicking on this field shows the schedule M.
  • E: button to display the report.
  • F: button to print the report.
  • G: button to save the report on disk (or USB key) in a variety of formats (including pdf).
  • H: possible types of filtering or not on contacts. Selecting None in such a list (no filter) is like selecting all (filter all possible cases). Selections can be single or multiple.
  • I: option to display a report by grouping the contact group.
  • J: to display a statistical graph.
  • K: Possible sorting.
  • L: button to display the graphs (this does not produce anything if J is not checked).
  • M: calendar in visual form to choose the date to show in C (or D).
  • N: button to display the window for data processing.
  • O: button to display the list of reports visible on the left.
  • P: to display the report without grouping operation.











  • A : minimum date of events to take into account for the report.
  • B : maximum date of events to take into account for the report.
  • C: display the report.
  • D: direct printing of the report.
  • E: backup report.
  • F: grouping option (can be grouped here by event type, entity type, etc..) or do not group (K).
  • G: Possible event types (and the same kinds of lists for types of entities, places, etc..).
    Selecting no element in such a list (no filter) is like selecting all (filter all possible cases).
    Selections can be single or multiple.
  • H: Possible sorting.
  • I: possibility of statistical graphs.
  • J: button to display checked graphs. If no graph is checked, clicking on this button (in the case of this report on the events) still displays a report (crosstab counting the Ascendants versus the signs):


    A
    Buttons to save, print or zoom the report.
    B
    Report title.
    C
    Filter used on the data.
    D
    Caption.
    E
    Ascendants.
    F
    Signs.
    G
    Numbers (at the letter G itself, there is zero event here having Gemini sign and Sagittarius Ascendant).
    H
    Number of events by sign.
    I
    Number of events by ascendant.

  • K : option of report with no grouping.

Viewing a report

Simple report










  • A: save the report in a variety of formats (including pdf).
  • B: printing the report.
  • C: if multiple pages for the report, access to the first page.
  • D: If multiple pages, access to the previous page.
  • E: ... access to the next page.
  • F: ... Access to the last page.
  • G: number of the current page.
  • H: report displayed in normal size.
  • I: report displayed so to see it fully (without the need for scrolls).
  • J: report displayed to occupy the entire width of the window.
  • K: magnification of the display.
  • L: reduction of the display.
  • M: Specifying the zoom.
  • N: report title.
  • O: filter used.
  • P: title of columns or fields of information.
  • Q: detail of the report.
Report with grouping










In A, the grouping name is indicated
(The report is grouped here by Event type and page 9 shows 4 groupes, like Bombing).
Graph










  • A: Indication of what is counted (here the number of events per type of event).
  • B: Name of the different groups (here the types of events). Note that when there are only one or two elements in a given group (in this case only one or two events for a given event type) then the graph shows them together under the name "...".
  • C: graphic representation of the number of items per group (number of events per type of event).