Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
|
blocks:dashboard:userguide [2017/08/11 22:51] admin [Ecrire et tester la requête de base] |
blocks:dashboard:userguide [2020/04/07 11:06] (Version actuelle) |
||
|---|---|---|---|
| Ligne 14: | Ligne 14: | ||
| there are 6 main steps in setting up a dashboard query: | there are 6 main steps in setting up a dashboard query: | ||
| - | * Carefully identify in which tables and which fields are the data that represents the query | + | - Carefully identify in which tables and which fields are the data that represents the query |
| - | * Identify the dimensions of sorting and filtering | + | - Identify the dimensions of sorting and filtering |
| - | * Write and test the base query form in a DB client | + | - Write and test the base query form in a DB client |
| - | * Copy the query in the dashboard | + | - Copy the query in the dashboard |
| - | * configure the output (data tables or graphs) | + | - configure the output (data tables or graphs) |
| - | * Setup accessories, (filters, parameters, colorizers, sub-totals, summators, etc). | + | - Setup accessories, (filters, parameters, colorizers, sub-totals, summators, etc). |
| ==== Think about the problem (identify the query) ==== | ==== Think about the problem (identify the query) ==== | ||
| Ligne 47: | Ligne 47: | ||
| * Use complex subqueries that multiplies the ORDER BY or GROUP BY clauses. | * Use complex subqueries that multiplies the ORDER BY or GROUP BY clauses. | ||
| - | ==== Mettre en place la requête ==== | + | ==== Enter the query in the Dashboard configuration ==== |
| - | La mise en place de la requête dans le tableau de bord est la première chose à faire réellement dans le tableau de bord. | + | copy the query in the query text area of the dashboard is the effective first thing to do. |
| - | - Passez le cours en mode édition | + | - Switch to the course editing mode |
| - | - Editez les paramètres du bloc Tableau de Bord à configurer | + | - Edit the block's settings |
| - | - Dépliez la rubrique //Paramètres du tableau de bord// | + | - Expand the //Dashboard settings// form section |
| - | - Cliquez sur //Accédez à la définition du tableau de bord// | + | - Click on the //Access to dashboard settings// |
| - | Le premier onglet est là où vous allez poser la requête. | + | The first panel shows the textarea where to put the query. |
| - | ==== Détail des écrans de configuration ==== | + | ==== Dashboard configuration screen details ==== |
| - | * [[:BlockDashboardConfigQuery|Configuration de la requête]] | + | * [[:BlockDashboardConfigQuery|Query]] |
| - | * [[:BlockDashboardConfigUserParams|Configuration des paramètres utilisateur]] | + | * [[:BlockDashboardConfigUserParams|User params]] |
| - | * [[:BlockDashboardConfigOutputFields|Configuration des informations de sortie]] | + | * [[:BlockDashboardConfigOutputFields|Data output]] |
| - | * [[:BlockDashboardConfigOutputTabular|Paramètres supplémentaires des sorties en tables croisées]] | + | * [[:BlockDashboardConfigOutputTabular|Data matrix additional params]] |
| - | * [[:BlockDashboardConfigOutputTreeview|Paramètres supplémentaires des sorties en arbre hiérarchique]] | + | * [[:BlockDashboardConfigOutputTreeview|Data tree view additional params]] (Pro Version) |
| - | * [[:BlockDashboardConfigPlotting|Configuration de l'affichage en graphe]] | + | * [[:BlockDashboardConfigPlotting|Graphic output]] |
| - | * [[:BlockDashboardConfigSummarizers|Configuration des sommateurs]] | + | * [[:BlockDashboardConfigPlotting|Additional GoogleMap parameters]] (Pro Version) |
| - | * [[:BlockDashboardConfigColoring|Configuration de la colorisation de données]] | + | * [[:BlockDashboardConfigPlotting|Additional timeline parameters]] (Pro Version) |
| - | * [[:BlockDashboardConfigScheduling|Configuration du raffraichissement de données]] | + | * [[:BlockDashboardConfigSummarizers|Summators and filters]] |
| - | * [[:BlockDashboardConfigFile|Configuration de la sortie sur fichier]] | + | * [[:BlockDashboardConfigColoring|Data coloring]] (Pro Version) |
| + | * [[:BlockDashboardConfigFile|Data export to files]] | ||
| + | * [[:BlockDashboardConfigScheduling|Data export sheduling]] (Pro Version) | ||
| - | [[:Blocks:Dashboard|Retour à l'index du bloc]] | + | [[:Blocks:Dashboard|Back to the plugin index]] |