Calender Issue

[#1]

Hi,

I am facing one issue which are explain in detail:

Step1:   I have three seperate Calender all three calender link with Fact table Date field.

             Example:  Calender date (Link_date)

                              Fact Date:  Registration_date, Closed_date and Purchse_date.

Step 2:  I have created seperete Calender1 and pass field as variable.

Step 3:   Expression like this: 

=

count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"}>} CALL_ID)

monthStartDate: 

=

date(MonthStart(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

monthEndDate:

=date(MonthEnd(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

Problem : when I select [Fiscal month Year]  of seperate Calender1 this is not working.

Please help on this.

Regards

Ravi Gupta

[Anonymous]

Hi Ravi

Is Calendar1 linked with the fact table?

Could you please upload the tables viewer snapshot?

Regards

MultiView

[#3]

[er_mohit]

have you tried like this way   for this field

count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"},[Fiscal month Year]=>}CALL_ID)

[#5]

Hi,

Please Find out image.

Common Calender: ( Registration_Date, Closing_date, Purchase_date)  as link Date

fact date field:  Registration_Date, Closing_date, Purchase_date

Seperate Calender: Calender1 and field: [link date]

Expression:  count(DISTINCT {<[REGISTRATION DATE]={">=$(monthStartDate) <=$(monthEndDate)"}>} CALL_ID)

monthStartDate:  date(MonthStart(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

monthEndDate:  date(MonthEnd(AddMonths(date(max([Link Date])),0)),'DD-MM-YYYY')

Pass [link date] as input field and I want to use seperate calender.

Please help.

Regards

Ravi Gupta

[#6]

Hi,

When I try show data  but data shown wrong.

=

count(DISTINCT {< [Fiscal MonthYear]=, [REGISTRATION DATE]={">=$(vMinDate) <=$(vMaxDate)"}>} CALL_ID)

Please check  image  file.

where output repaering value.

regards

Ravi

[#7]

Hi ,

Please find output

Total	13	2	15%
Jan-2010	13	2	15%
Feb-2010	13	2	15%
Mar-2010	13	2	15%
Apr-2010	13	2	15%
May-2010	13	2	15%
Jun-2010	13	2	15%
Jul-2010	13	2	15%
Aug-2010	13	2	15%
Sep-2010	13	2	15%
Oct-2010	13	2	15%
Nov-2010	13	2	15%
Dec-2010	13	2	15%
Jan-2011	13	2	15%
Feb-2011	13	2	15%
Mar-2011	13	2	15%
Apr-2011	13	2	15%
May-2011	13	2	15%
Jun-2011	13	2	15%
Jul-2011	13	2	15%
Aug-2011	13	2	15%
Sep-2011	13	2	15%
Oct-2011	13	2	15%
Nov-2011	13	2	15%
Dec-2011	13	2	15%
Jan-2012	13	2	15%
Feb-2012	13	2	15%
Mar-2012	13	2	15%
Apr-2012	13	2	15%
May-2012	13	2	15%
Jun-2012	13	2	15%
Jul-2012	13	2	15%
Aug-2012	13	2	15%
Sep-2012	13	2	15%
Oct-2012	13	2	15%
Nov-2012	13	2	15%
Dec-2012	13	2	15%
Jan-2013	13	2	15%
Feb-2013	13	2	15%
Mar-2013	13	2	15%
Apr-2013	13	2	15%
May-2013	13	2	15%
Jun-2013	13	2	15%
Jul-2013	13	2	15%

[#8]

Hi Mohit and Multiview,

I am waiting for your reply.

Regards

Ravi Gupta