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

    Dashboards

    Apprentice
    brian_bakewell Jun 27, 2012 3:37 AM

      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
          mmorales Jun 27, 2012 4:48 PM (in response to brian_bakewell)

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

          • 2. Re: Dashboards
            Apprentice
            brian_bakewell Jun 28, 2012 2:11 AM (in response to mmorales)

            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
              paul.enkelaar Jun 28, 2012 5:53 PM (in response to brian_bakewell)

              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