week days in Bar graph

[#1]

HI all,

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.

Thanks,

pramod

[rubenmarin]

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.

[#3]

Hi ruben,

sorry, you are correct invitation_id are on mondays only, but the other two counts have data on other days of the week.

Thanks,

Pramod

[rubenmarin]

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

[#5]

Hi Ruben,

I got it. but how to use the dates from the signup and course completion table to get the required output.

Thanks,

Pramod