Calendar Help...

[leocattqv]

Hi all,

I have a dashboard that I am attempting Failure Rate % = Customer Feedback / Sales

So I have a Star Schema that does not have any Synthetic keys.

I am tracking Customer Feedback and Customer Sales

When I select Calendar fields I get only Sales data

Are the Date ID's in the same format - Yes

Is Customer Feedback and Sales linked - Yes (or as least as far as I can tell)

The part that gets me is that I can get an overall Failure by whatever I want - except Calendar

I have attached the QVW - I am looking for tips and tricks to find out where I have gone wrong - at this for a few days now and getting desparate.

[jwjackso · Accepted solution]

Looking at the data in you QVW, The complaints are associated with MasterKey records that either do not have a DateID or the DateID is a timestamp.

[leocattqv]

          That was it, thanks Jerry, I adjusted the DateID and walllah

I appreciate the help