weekdays

[#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

[Gysbert_Wassenaar]

In the attached .qvf file. for the client id = 15, all the data is showing only for Monday.

There is only data for the Mondays in the week_Day dimension for client id 15.

but the data should display on the particular day.

I don't understand. Can you explain with an example what you mean?

[#3]

HI Gysbert Wassenaar,

In image you can see bars are displaying only for monday.

     The CTR measure is having only on monday. but other two measures (signups and completion) have data on other days(tue,wed, thu,fri,sat, sun) instead of displaying on other weekdays, those data is also dispalying on monday.

Thanks,

Pramod

[Gysbert_Wassenaar]

The other measures do not have data on other days in the week_Day dimension for client id 15.

[#5]

HI Gysbert Wassenaar,

In the attached image you can see the data on other days of the week.

I think for week_Day dimension, i have used the "date_created" field. This is not in other two tables. May be this is causing the issue.

Iin the weekdays.qvf attached file you can see the sheet2 where it shows the data of other two measures.

Will you please check and help on it.

Thanks,

Pramod

[Gysbert_Wassenaar]

Let's try that again:

The other measures do not have data on other days in the week_Day dimension for client id 15.

The week_Day1 and week_Day2 dimensions are not the week_Day dimension. You cannot show values from three different dimensions in that one dimension you used in your chart.

[#7]

sorry. you are correct.

Week_Day don't have data for other days. but it have data for week_Day1 and week_Day2.

I need to combine all three and need to display the data. Is this possible?

I read that we can combine all date fields through master calendar or cannonical date. Is that possible?

If possible please explain how to do it for our date fields?

Thanks,

Pramod

[Gysbert_Wassenaar]

A canonical date calendar is possible. This blog post can tell you how to do that: Canonical Date. Or perhaps this one: Linking to two or more dates

[#9]

HI Gysbert wassenaar,

I read and used the below code. but i'm not getting where i have done wrong.

T1:

LOAD `invitation_id`,

date_created as commondate;

SQL SELECT date_created,

`invitation_id`

FROM rcdbrpt.invitation;

T2:

LOAD date_signed as commondate,

SQL SELECT date_signed

FROM rcdbrpt.signupactivitylog;

T3:

LOAD date_completed as commondate;

SQL SELECT date_completed

FROM rcdbrpt.coursecompletion;

Please help how to use canonical date for my date fields.

Thanks,

Pramod