How to Avoid Circular Loop

[vengadeshpalani]

Hi

in the dashboard, I show the count of the pending job based on date wise, month wise and year wise

but In data model, JobID = MJobID = YJobID  if I maintain the same name it make circular loop

how can I make the perfect data model

PFA for sample Qvw

[aarkay29]

PFA

Not sure what exactly wanted but made some changes. Please go through and let me know if you need something other than that.

Thanks,

AAR !

[vengadeshpalani]

in updated data model there is no connection between master calendar and Month/year table 

so if i click month in the calender it show the wrong result that means it show completed job also

[aarkay29]

To my knowledge this type of the data model is applicable for your requirement may be your calculation needs to be changed according to your requirement.

Can you please, post sample output where the current calculation is wrong and what number you expect to see instead .

[awhitfield]

Hi,

looks like you need multiple calendars, please check out the following link:

Canonical Date

Andy