In the attached .qvf file. for the client id = 15, all the data is showing only for Monday.
but the data should display on the particular day.
Please help me to get the data according to the days.
Hi Pramod, seems it's ok, all the invitation_id are on mondays except 1 that was on 28/10 (tuesday) and it's counted as 1 in tuesday.
sorry, you are correct invitation_id are on mondays only, but the other two counts have data on other days of the week.
Hi Pramod, in your model the tables with signup and course completion are related to the invitations table, and the field week_Day only exists in the invitation so those expressions are showing:
- Number of signups by day of the invitation
- Number of couse completions by day of the invitation
Check this post by Henric, hope that helps: Canonical Date
I got it. but how to use the dates from the signup and course completion table to get the required output.