• Preface
  • Introduction
  • How to use this manual
  • What's new
    • What's new in Version 5.16
    • What's new in Version 5.15
    • What's new in Version 5.14
    • What's new in Version 5.13
    • What's new in Version 5.12
    • What's new in Version 5.11
    • What's new in Version 5.10
    • What's new in Version 5.9
    • Older Versions
  • Getting started
    • TIS launch pad
    • Components of TIS
    • Getting started with TIS Board
      • TIS Board login
      • Create a Page
      • Using Boards
      • Anleitung zur Benutzung des [TIS]Board
      • Arbeiten mit dem [TIS]Board: Quick Guide
      • Elemente im [TIS]Board: Quick Guide
    • Core Elements of the TIS Architecture
    • Definitions within TIS
  • Reference
    • TIS Editor
      • Introduction to the TIS Editor
      • Premises on using TIS Editor
      • Elements of TIS Editor
        • Homepage
        • TIS Project
          • Manage TIS Projects
            • Copy a TIS Project
            • Delete a TIS Project
            • Replace a TIS Project
            • Export & Import Projects in TIS Editor
            • Export & Import Projects in TIS Board
            • Design reusable and adaptive Projects
            • Keep the overview in large projects
            • Minimize errors in TIS Projects
        • Data Node
          • Filter data in a data node
          • Update process between data nodes
          • Move an operation to its parent node
          • Manage Data Node
          • TIS Board connection of a data node
        • Operator
          • TIS Board operator
        • Operation
        • Parameters
          • The three most important issues for Parameters
          • Find empty strings in parameters
          • Use Parameters for Operators
          • Use General Parameters
            • General Parameters in the "Formula Operator v04"
            • General Parameters in the "Import data from SQL sources v03" Operator
            • How to work with Parameters in TIS Board?
            • Creating Formatted Controller Portlets
            • Trouble Shooting with Parameters
        • Data Management
          • Manage data in the TIS Editor
            • Upload or download a data file to the TIS Server
            • Export data to Excel
            • Export data to CSV
            • Export data to a TIS table
            • Export data to ODBC interface
        • TIS Table
      • List of Operators (functional)
        • Qmetrix Operators
        • XIH Functions
        • Regular Expressions
      • List of Operators (alphabetical)
        • Thread column values
        • Chart: Gantt 2D
        • Rename, reorder and delete columns
        • Identifier instances
        • Identifier filter
        • Scaling 7.0
        • Link to calendar
        • Absence rate [Translated]
        • Test operator
        • Chart: Histogram Time Pattern
          • Format a chart in TIS Editor
        • TIS Board - Read editable data table 5.0
        • Delete rows
        • Formula operator (row-by-row) (5.0) = Formeloperator
        • Scaling 8.0
          • Use cases for allocation-oriented methods
          • Use cases for value-oriented methods
          • Scales
          • Calculation methods
        • Convert "Date/Time"
        • Pivot table time x weekdays 2.0
        • Formula operator (row-by-row) (4.0) = Formeloperator
          • Easier editing in the Formula Operator
          • Formula operator: Conversion and Formatting
          • Formula operator: XIH Helper Functions
          • Find a row that causes the Formula Operator to stop
          • Formula operator: Date and Time
          • Formula operator: General Mathematics
          • Formula operator: Extras
          • Formula operator: Text
        • Combine columns
        • @Timer
        • Create Table
        • Mix columns
        • Normalizing (time of day)
        • @Save Table
        • Filter on columns 1.1
        • @GenericACDImport
        • @Smoothing2
        • @SaveTableToDataCache
        • @SPX Time Converter
        • @DateTimeFilter2
        • @Load Table
        • Calculate Min/Max
        • @ImportFromDataCache
        • Normalizing (date)
        • @Table Editor 3
        • Split Columns
        • Format columns 2.0
        • @Add Values
        • General Calendar
        • @Odbc Export Operator
        • @Merge Queue Data 2
        • Conversion of time pattern
        • @Offset
        • @AggregationXimes
        • Absence rate
        • As a percentage 4.0
        • Day or week profiles 2.0
        • Sum and count
        • Cut values
        • Missing/overlapping time intervals
        • Select data source
        • Pivot table
        • Start process 2.0
        • Chart: Histogram
        • Analyze text pattern
        • Replacing null values
        • Merge data 4.0
        • Chart: Standard types 2.0
        • Imports text or CSV file with XML structure description
        • Generate shifts
        • Delete columns
        • Trigger shift generation 2.0
        • Resolve pivot table 2.0
        • QMETRIX time periods
        • QMETRIX traffic light 1.0
        • Conversion "String -> Date 2.0"
        • Freeze columns 2.0
        • Token Validation 1.0
        • Stimulsoft report - export sample data 1.0
        • Conversion "String -> Double"
        • Statistical evaluations
        • @OpTISBoardQuickView
        • Export to CSV file (TIS file system) 2.0
        • [TIS]Board - Recalculate in update interval 1.0
        • Format columns of 'Editable Grid' 1.0
        • Export in CSV file (server file system) 2.0
        • Copy or delete TIS tables
        • Regression analysis
        • Qmetrix Xml Writer
        • Time grouping 2.0
        • TIS Board - HTML
        • Encrypt text
        • Sort Rows
        • Chart: 2D Map (Pivot start table)
        • Chart: 2D Map (Start table list)
        • Chart: XY Scatter
        • Retail (sales volume and employees)
        • Time interval between rows
        • Search for outliers
        • QMETRIX Visualization lining 1.0
        • Read TIS table information
        • QMETRIX Definition lining 1.0
        • Collect report data 2.0
        • Write TIS table 3.0
        • Read TIS table 5.0
        • QMETRIX Waiting time calculation
        • Send e-mail 2.0
        • Optimizer: Sequence Simple
        • Formula interpreter 3.0
        • Create Pivot Table V2
        • Delete duplicated data records
        • Import text or CSV file 3.0
        • Seasonal ARIMA analysis 5.0
        • TIS Board - TIS Editor Chart
        • Length operator
        • Python Scripting
        • TIS Board - Adjust Portlet
        • Importing data from SQL sources 3.1
        • TIS Board - EJSChart Histogram 2.0
        • TIS Board - Adjust portlet if column changes 1.0
        • TIS Board - Multiple selection 3.0
        • [TIS]Board - Recalculate multi-selection 1.0 (deprecated)
        • Convert "From-Date/From-Time/To-Time"
        • Regression analysis seasonal 6.0
        • TIS Board - Editable EJSChart 1.0
        • TIS Board - Editable EJSChart Histogram 1.0
        • TIS Board - Recalculate 3.0
        • TIS Board - Upload file 1.0
        • TIS Board - Selection list for editable data table
        • TIS Board - Gauge 1.0
        • TIS Board - EJSChart 3.0
        • TIS Board - Generate editable data table 4.0
        • TIS Board - Stimulsoft report viewer 2.0
      • Types of Tables
      • Status Symbols
      • Naming conventions
      • Column references
    • TIS Board
      • Introduction to the TIS Board
      • Elements of TIS Board
        • Page tree
        • Portlet
          • Create a Portlet
          • Admin Portlet
          • List of Portlet Properties
          • Portlet Property
        • Portlet Explorer
        • Portlet Designer
        • Page
      • List of Portlets
        • Simple Grid (Portlet)
          • Create Sparklines in Simple Grid Portlets
        • Chart (Portlet)
        • EJS Chart (Portlet)
        • Quick View (Portlet)
        • HTML (Portlet)
        • Editable Grid (Portlet)
        • Editable EJS Chart (Portlet)
        • Controller (Portlet)
        • Gauge (Portlet)
        • File Upload (Portlet)
        • Tile (Portlet)
        • Stimulsoft (Portlet)
          • Designing a Stimulsoft Report
          • Stimulsoft Report with stacked/nested crosstabs
        • SPX Picker (Portlet)
      • Working with Portlets and Pages
        • Design Boards & Pages
        • Creating and editing pages
        • Managing and formatting single pages
        • Navigation Button
        • Formatting and Working with Portlets
          • General Elements for all or most Portlets
          • Formatting Elements for all or most Portlets
          • Further Elements for specific Portlets
          • Conditional Formatting for Grids
          • Managing Portlets
          • Using pictures and videos in HTML Portlets
        • Refreshing Portlets on Tab Change
        • Actions and their consequences
        • Event Handling with Portlets
      • Operator Portlet Compatibility
      • Keyboard Shortcuts
        • Shortcuts TIS Board Resources
        • Shortcuts TIS Board View Mode
        • Shortcuts TIS Board Edit Mode
      • Copying Data between Excel and TIS Board
      • View and edit modes
    • TIS Admin
      • Roles
      • Users
      • How to set up a new user
    • Advanced Issues
      • Management of data sets
        • How to work with large data sets
        • Switching between data sets
        • How to prepare Data for using Standard Packages
        • How to deal with many data and several variables?
        • Updating of Edited Data
          • Join before Init
          • Method csv
          • Method TIS-Table
          • Method Append
      • Managing Pages and Projects
        • Introduction & Mechanisms
        • Working with Template Projects
        • Templates = Using Boards with many users
          • Visibility & Publication of Pages
          • Deploy Pages & Delete deployed pages
          • Master portlets
        • Ownership of Projects & Administration Portlets
        • Licensing & Report Type
        • Further Administration Portlets
        • Changing Resources
      • Advanced Usage TIS Board
        • Updating Pages on Opening
        • Change the Default Client for TIS Board Login
        • Setting a different Logo
        • Adjust Portlet properties dynamically
        • Deactivate Startup Tips
        • Remote control API to change TIS Board State
        • JavaScript Settings of TIS Board - TISBoardSettings.js
        • Change Online Help
        • Resources
        • Hiding Zero Values
        • Using Links (e.g. for icons) in Texts and Resources
      • OPA in TIS Optimizing Shifts and Staffing
      • Setting up a cron job
      • Solution Runner
      • Developing Solutions - when to log out?
      • Switching between Languages / Translation
      • Run in 32-bit mode
      • File Guard Configuration
      • Active Directory (AD) authentication configuration
      • eTermin in TIS
    • Deployment
      • System requirements up-to version 5.16
      • Localization
      • Create a new client
      • HTTPS Configuration
      • Load Balancing
      • SP-EXPERT Compatibility up-to version 5.16
      • Delete an existing client
  • TIS Training
    • Basic training
    • Advanced training
    • Exercise extra
    • Exercises
      • Ãœbungsbeispiel 6.1
      • Ãœbungsbeispiel 4.1
      • Exercise 5 "Chat"
      • Ãœbungsbeispiel 4.2
      • Exercise 6.4
      • Exercise 6.2
      • Ãœbungsbeispiel 6.4
      • Ãœbungsbeispiel 7
      • Ãœbungsbeispiel 6.3
      • Ãœbungsbeispiel 2
      • Exercise 1.2
      • Ãœbungsbeispiel 1.3
      • Ãœbungsbeispiel 1.2
      • Ãœbungsbeispiel 1
      • Ãœbungsbeispiel 8
      • Ãœbungsbeispiel 9
      • Exercise 9
      • Ãœbungsbeispiel 1.1
      • Exercise 4.1
      • Ãœbungsbeispiel 7.1
      • Exercise 7.1
      • Exercise 7.2
      • Ãœbungsbeispiel 6
      • Exercise 6.1
      • Ãœbungsbeispiel 7.2
      • Ãœbungsbeispiel 5.2
      • Ãœbungsbeispiel 5.1
      • Ãœbungsbeispiel 3
      • Exercise 8
      • Ãœbungsbeispiel 6.2
      • Ãœbungsbeispiel 10
      • Ãœbungsbeispiel 11
      • Ãœbungsbeispiel 14
      • Ãœbungsbeispiel 12
      • Ãœbungsbeispiel 13
      • Exercise 6.3
      • Exercise 1
      • Exercise 6
      • Exercise 4.2
      • Exercise 1.3
      • Exercise 1.1
  • Glossary
  • Appendix
    • Pages by German names
      • Stimulsoft Report - Beispieldaten Export 1.0
      • Zeitrasterkonvertierung
      • Identifizierer Filter
      • Handel (Umsatz und Besetzung)
      • Identifizierer Ausprägungen
      • Import Text- bzw. CSV-Datei mittels XML-Aufbaubeschreibung
      • In Prozent 4.0
      • Formeloperator (zeilenweise) (4.0)
      • Formelinterpreter 3.0
      • Fehlende/Ãœberlappende Zeitintervalle
      • Spalten splitten
      • Zeitintervall innerhalb einer Zeile
      • Pivottabelle erstellen V2
      • Umwandlung "String -> Double"
      • Umwandlung "String -> Datum 2.0"
      • Textmuster analysieren
      • TIS Tabelleninformation lesen
      • Null-Werte ersetzen
      • Prozess starten 2.0
      • Kreuztabelle
      • Pivottabelle Uhrzeit x Wochentage 2.0
      • Doppelte Datensätze löschen
      • Spalten umbenennen, umsortieren und löschen
      • Filter auf Spalten 1.1
      • Tabelle erzeugen
      • Tages- oder Wochenprofile 2.0
      • Spalten einfrieren 2.0
      • QMETRIX Festlegung Lining 1.0
      • Regressionsanalyse saisonal 6.0
      • QMETRIX Visualisierung Lining 1.0
      • QMETRIX Zeitbereiche
      • Rastern 8.0
      • QMETRIX Wartezeitberechnung
      • Spalten zusammenfassen
      • Rastern 7.0
      • QMETRIX Ampel 1.0
      • Verknüpfen mit Kalender
      • Zeilen löschen
      • Zeilen sortieren
      • Umwandlung "Datum/Von-Uhrzeit/Bis-Uhrzeit"
      • Zeit gruppieren 2.0
      • TIS Tabelle lesen 5.0
      • Trigger Dienstgenerierung 2.0
      • TIS Tabelle schreiben 3.0
      • Text verschlüsseln
      • Umwandlung "Datum/Uhrzeit"
      • TIS Tabellen kopieren oder löschen
      • Importieren von Daten aus SQL-Quellen 3.1
      • Datenquelle auswählen
      • Diagramm: Histogramm
      • Diagramm: Gantt 2D
      • Diagramm: Punkt (XY)
      • Diagramm: Standarddiagramme 2.0
      • Diagramm: Histogramm Zeitraster
      • Diagramm: Landkarte 2D (Ausgangstabelle Liste)
      • [TIS]Board - Neu berechnen Mehrfachauswahl 1.0
      • Diagramm: Landkarte 2D (Ausgangstabelle Pivot)
      • [TIS]Board - Neu berechnen 3.0
      • [TIS]Board - Tachometer 1.0
      • Daten zusammenfassen 4.0
      • Ausreisser suchen
      • [TIS]Board - Editierbares EJSChart Histogramm 1.0
      • [TIS]Board - EJSChart Histogramm 2.0
      • [TIS]Board - Mehrfachauswahl 3.0
      • [TIS]Board - Editierbare Datentabelle holen 5.0
      • [TIS]Board - Editierbares EJSChart 1.0
      • [TIS]Board - [TIS]Editor Grafik
      • Import Text- bzw. CSV-Datei 3.0
      • [TIS]Board - Portlet anpassen
      • Zeitintervall zwischen Zeilen
      • [TIS]Board - Neu berechnen im Aktualisierungsintervall 1.0
      • Tachometer (Portlet)
      • Dateiupload (Portlet)
      • Steuerung (Portlet)
      • Editierbares EJS Chart (Portlet)
      • Datentabelle (Portlet)
      • TIS Editor Grafik (Portlet)
      • Editierbare Datentabelle (Portlet)
      • Reportdaten sammeln 2.0
      • Export in CSV Datei (TIS-Dateisystem) 2.0
      • Verteilung
      • [TIS]Board - Portlet bei Spaltenänderung anpassen 1.0
      • Export in CSV Datei (Serverdateisystem) 2.0
      • Statistische Auswertungen
      • Pivottabelle auflösen 2.0
      • Spalten löschen
      • [TIS]Board - Datei hochladen 1.0
      • E-Mail senden 2.0
      • Spalten formatieren 2.0
      • Optimierer: Sequence Simple
      • Saisonale ARIMA-Analyse 5.0
      • Spalten mischen
      • Regressionsanalyse
      • Spalteninhalt verketten
      • Summieren und Zählen
      • Schichten generieren
      • Werte schneiden
      • [TIS]Board - Editierbare Datentabelle erzeugen 3.0
      • [TIS]Board - Stimulsoft Report Viewer
    • Data Types
    • Formatting strings
    • Miscellaneous definitions
      • TIS Solution developer
      • TIS Board User
      • Child node
      • Referenced node
      • TIS Solution
      • Parent node
    • Tipps für Reports (in Stimulsoft)
    • TIS Solution Datenreiniger
    • TIS Error Codes
    • TIService Settings
    • Typographic Conventions
    • Software Patches up-to version 5.15
    • TISInstaller Settings
  • Impressum