OCTOBOARD
Português
TARIFAS
RECURSOS
INICIAR SESSÃO
TRIAL
TRIAL
Português

GALERIA DE DASHBOARDS E RELATÓRIOS

Selecione a sua aplicação preferida na nuvem e crie o seu primeiro dashboard de Redes sociais ou Desempenho comercial.
TODOS OS DASHBOARDS
RETORNA / DASHBOARDS / GOOGLE BIG QUERY

GOOGLE BIG QUERY DASHBOARD

big-query

Octoboard data dashboard: Bigquery data connection in octoboard
Use this BigQuery 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 or BigQuery account to Octoboard please visit this Knowledge Base post.
Notas
When connecting to BigQuery, please enter your standard parameters - account name, project and dataset. For more details on how to create a generic database connection, please read this tutorial.
319
EXPERIMENTAR AGORA
Última revisão:
19-May-23
Dashboards:
Relatórios:
Portais de clientes:
Colocar White label:
Atualização dos dados:
Informações sobre dados:
Saída da TV de escritório:
Multicliente:

GOOGLE BIG QUERY MÉTRICAS

BIGQUERY NUMERIC

BigQuery Numeric widget
Descrição
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"
UTILIZAR ESTA MÉTRICA

BIGQUERY CATEGORY

BigQuery Category data widget
Descrição
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
UTILIZAR ESTA MÉTRICA

BIGQUERY HISTORICAL

BigQuery Historical data widget
Descrição
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.
UTILIZAR ESTA MÉTRICA