PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Collapse]Analytics
    [Expand]Installation and Administration
    [Expand]Planning
    [Expand]Ad-hoc Analyses
    [Expand]OLAP Reports
    [Expand]OLAP Analyses
    [Expand]Special Reports
    [Collapse]Dashboard
     [Collapse]Creating a Dashboard
      [Collapse]Create a Component
        Ad-Hoc analysis
        Ares
        Counter
       [Expand]Chart
        GoogleMaps
        Multicomponent
        PANTHEON Report
       [Expand]Table
        OLAP Analysis
        Tile
       Edit Components
       Copy Components
       ZEUS Authorizations
      Transfer dashboards
      Using the Dashboard
      Dashboard slideshow
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 515.6319 ms
"
   7521 | 7997 | 340951 | Updated
Label

Counter

Counter

010411.gif010382.gif010383.gif
  1. Enter any name and description for component in Name and Description field. 
  2. Paste an SQL query in the SQL box. It cannot exceed 8000 characters. Right-click and select Edit in SQL Editor command from the menu if you want to edit SQL query in editor.

33726.gif

  1. To prefetch data instead of running SQL query when opening dashboard, check Prefetch Data.After selecting this option, click Apply SQL. You have to click it also whenever you change an SQL query. 

    33708.gif

  2. Click Apply SQL.

  3. Set filter in order to filter data by set criteria. Take care to set criteria wisely. Typically, the filter is equivalent to the WHERE statement in SQL query.

  4. Check Use "Total" for dashboard component. Having checked Use "Total", the chart displays unfiltered values.

  5. In the Counter Range set minimum and maximum value. Set color for Range 1, Range 2 and Range 3. In addition you can also set borders. To use the section check Active.

        9.    Click 023791.gif to confirm it.


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!