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.
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.
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.