Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i am trying to show the count of employee and dependent by age wise in barchart. but i am getting incorrect values. i checked the data model also.
my approval date format like this
so i did this in back end to get date
date(Floor(MP_APPR_DT)) as APPROVED_DATE
from this APPROVED_DATE created master calendar.
while checking in DB the values getting in QV is incorrect.
i dont know what cause the issue.
please check the attached app.
this the expected output for the age range
some one please suggest some solution. its really urgent.
Thanks
14594 |
15088 |
61451 |
74968 |
24283 |
2423 |
TOTAL 192807 |
You have total employee
154773
How to match this?
Something wrong !
yes Manish bro,
that is the issue. while checking in DB i get this 192807. but in QV 154773.
i dont know what is the issue. can you check the issue please.
Comment for all other tables except the ME_AGE and EMPLOYEE ID and try to find out how many Employee_ID you are getting?
173714
Hi Arul, just to confirm... that results you expecting is the number of employees related to one of the 7811 policies approved in 2015?
Check the data model linking
this is the expected output for year 2015
i did sujeet. something else causing the issue.
Yes, I wanted to confirm that year is related to policies and policies to employees, so that's the results of the employees related to a policy approved in 2015.
Anyway in your answer to Manish, loading only the employee table you don't get so many employees, it's almost 20.000 employees short. This is weird, as you can't filter year the same way and results should be higher, you commented all other tables like Manish asked? In you sample counts 495.557 distinct employee ID removing year selections
Edit: it was 173.714, forgot I removed the "distinct" for testing.