3 Replies Latest reply on Jun 28, 2012 5:53 PM by paul.enkelaar

    Dashboards

    Apprentice

      Is it possible to get the daskboards to show the total of a field in a query for webdesk

       

      I know this can be done by using the agregates in console but I need to be able to just show the total of a field in webdesk. This can be in any of the Panels or will I have to create an external webpage running an SQL script to get this value?

        • 1. Re: Dashboards
          Expert

          While logged into webdesk, right click, add new gadget, count queries, select appropriate module and object, select querie(s)

          • 2. Re: Dashboards
            Apprentice

            Hi, this just totals the number of instances brought back, I need to total all the numbers in one field on an object. I've had a look at the properties but can't find anything

             

            Brian

            • 3. Re: Dashboards
              Expert

              Hi Brian

               

              I don't believe that dashboard queries can achieve what it is that you wish.  They don't have smarts behind them, for adding up various fields etc.  For this I think you need to turn to a reporting tool, such as Crystal Reports or similar.  In my case (where we need to total dollar amounts and time spent by analysts etc), we are using SQL Reporting Services (SSRS) for this, and so I have a URL link on my dashboard which takes the user to the SSRS server.

               

              Cheers

               

              Paul