gauge problem

[#1]

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!

[#2]

Nevermind i allready found the problem!

Thank you very much for your help kaushik!