UNDER DEVELOPMENT
OCTOBOARD
Deutsch
PREISGEBUNG
LOGIN
KOSTENLOSE TESTPHASE
KOSTENLOSE TESTPHASE
Deutsch

AUTOMATISIERTE BERICHTSVORLAGEN

Wählen Sie eine Vorlage aus und verwenden Sie unsere Reporting-Tools für Vertrieb, Finanzen, SEO und PPC, um automatisierte Berichte oder Online-Marketing-Dashboards zu erstellen.
ALLE DASHBOARDS ANZEIGEN
HOME / DASHBOARDS / REDSHIFT

REDSHIFT DASHBOARD

Redshift database connection.

Octoboard data dashboard: Redshift database dashboard in octoboard
Use this RedShift database connection to add historical data widgets, pie charts and numeric widgets to Octoboard business performance dashboards, automated reports and white label client portals.

For more details on how to connect your database to Octoboard please visit this Knowledge Base post.
Hinweise
Please use standard Redshift connection parameters - database name, host name, ip address, port, login details and security settings.
346
VERSUCHEN SIE ES JETZT
Zuletzt überprüft:
2-Sep-21
Dashboards:
Berichte:
Kundenportale:
White Label:
Daten aktualisieren:
Daten-Einblicke:
Büro-TV-Datenausgabe:
Multi-Kunde:

REDSHIFT MESSGRÖSSEN

REDSHIFT NUMERIC

Redshift Numeric widget
Beschreibung
This widget displays a single numeric value. SQL statement should return a single column. The very first value will be read and displayed in the widget. In the following example, SQL statement returns population of USA:

SELECT population FROM countries WHERE country="USA"
DIESE METRIK VERWENDEN

REDSHIFT CATEGORY

Redshift Category data widget
Beschreibung
Category widget displays values in tables or pie charts. SQL statement should return two columns. First column should contain category name, second column should return numeric values.

In the following example, SQL statement retrieves country names and country population. Pie chart will display countries ranked by population size:

SELECT country, population FROM countries
DIESE METRIK VERWENDEN

REDSHIFT HISTORICAL

Redshift Historical data widget
Beschreibung
Historical data widget displays historical data in a column, line or area graph. SQL statement is expected to return two columns. The first column should have dates, second one should have values.

In the following example, SQL statement retrieves shares price for Apple.

SELECT date, price FROM stock WHERE ticker="AAPL"


Make sure you sort results by date. Sequence of returned data raws is important. The platform will display first 1000 rows that it retrieves.
DIESE METRIK VERWENDEN