Can any one give me example on how to count previous month data..
For example If I am having Tickets of current months along with previous month I need to show the percentage of that so how to write expression for that. If I am not wrong I need to use range count
Here I am having Tickets and Target tickets Here when I am select current month the data should accumulate with previous month and to show percentage for that
Here month field is dimension and if I select Service it should take count from june to september and to show % of that field
I.e Target tickets/Total tickets of that field.
Hope I am clear I am attaching sample data for better understanding
