10 Replies Latest reply: Aug 2, 2012 9:14 AM by thijmenbosman RSS

    gauge problem

      Dear community,

       

      I have a problem creating a gauge using data in a specific set

       

      The gauge is ment to display a percentage of used data in a month

       

      I need it to allways display data in the current month and year, no matter what the selection.

       

      The data is displayed in cdr_data_in_kb and it is separated in different categories. I only need it to display data in the category DBS1, the category is named dataservice_type

       

      so far i created this analysis

       

      =avg({$<dataservice_type={$(='dbs1')}>}cdr_data_in_kb)

       

      It does not display the correct data when i select the month and the year mannualy and it does not change when i select no month or year (which it should)

       

      Does anyone know what i am doing wrong?

       

      Bonusquestion; how do i show the data in MB in stead of KB? /1024 does not seem to work with the gauges

       

      Thank you for your help!

        • Re: gauge problem
          Kaushik Solanki

          HI,

           

              What i understood is you want to have a gauge chart which shows you the percentage usage of the category DBS1 in comparision with over all usage. And that too only for current Month and Year. If yes then try this expression in guage chart.

           

          Sum({<dataservice_type = {"dbs1"},Month = {"$(=Max(Month))"},Year = {"$(=Max(Year))"}>}cdr_data_in_kb)

          /

          Sum({<Month = {"$(=Max(Month))"},Year = {"$(=Max(Year))"}>}cdr_data_in_kb)

           

          And go to Number tab of the chart properties and select the show in percentage option.

           

          Bonus Answer. When you are taking the percentage it doesnt matter whether the data is in KB or in MB. For example If I have 10240 KB /  1024000 KB will give me 10% and same if i Use in MB 10 MB / 100 MB will also give me 10%.

           

          Hope this will help.

           

          Regards,

          Kaushik Solanki

            • Re: gauge problem

              Hi Kaushik,

               

              Thank you for your answer but i need the gauge to show the amount of data used in the DBS1 category compared by the maximum availablein the DBS1 (max available would be bundle_size_mb * amount of DBS1 connections in database)

               

              or

               

              the amount of data used in MB on average

               

              i am guessing the AVG function is a better solution, but i do not know for sure