Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to know how to get 1 month, 3month, 6month,9month and 12 month sales, help me how to write calculation to data
1 | = count(claims) for vehicle with time in service <=1 * 100 / count(vehicle with time in service <=1) | |||||||||||||||
3 | = count(claims) for vehicle with time in service <=3 * 100 / count(vehicle with time in service <=3) | |||||||||||||||
6 | = count(claims) for vehicle with time in service <=6 * 100 / count(vehicle with time in service <=6) | |||||||||||||||
9 | = count(claims) for vehicle with time in service <=9 * 100 / count(vehicle with time in service <=9) | |||||||||||||||
12 | = count(claims) for vehicle with time in service <=12 * 100 / count(vehicle with time in service <=12) |
assuming you have fields already created as you describe have you tried
for vehicle with time in service <=1 etc...
count({<[time in service]={"<=1"}>}claims)
count({<[time in service]={"<=3"}>}claims)
count({<[time in service]={"<=6"}>}claims)
count({<[time in service]={"<=9"}>}claims)
count({<[time in service]={"<=12"}>}claims)
into your calculations?