Table name: u_company_roles
field name= License allocated and License usage
Basically this table holds details license allocated for each company and license being utilized. Now we can get the details of usage vs allocation on current date but i want to build a report which can show me allocated and usage for each company foe each month.
I tried creating a metric definition and db view as below
DB view for company role table,metric definition and metric instance as below:
But still not able to achieve report on monthly basis. Any help would be appreciated
