Master Calendar for Different Date Columns in different tables

[bvssudhakar]

Hello Experts,

I have loaded 6 to 7 sql query tables all of them are having different date columns so for them I want create one master calendar how can we create that calendar and how can we create the relationship for them

Please Help me out from this

stalwar1‌

Thank you in Advance

Regards,

B V S Sudhakar

[sunny_talwar]

Check this out

Canonical Date

[kfoudhaily]

I find this article from @HIC interresting too:

Why You sometimes should Load a Master Table several times

regards,

[bvssudhakar]

Hello Guys,

Here i attached sample Excel sheet, In this table 5 to 6 date columns are there

Example: i am creating one bar chart/table for title name wise placements for this i use title name as dimension and =Count({<plcdate = {"*"}>}CandidateID) as expression

and now i have to create one list box for plcdate column

And now, again i am creating one bar chart/table for title name wise Declines for this i use title name as dimension and =Count({<Declinedate = {"*"}>}CandidateID) as expression

for this i have to create one more list box for Decline date column

Again i am creating one bar chart/table for title name wise Offered Candidates for this i use title name as dimension and =Count({<Offerdate = {"*"}>}CandidateID) as expression

for this i have to create one more list box for offer date column

But user is not accepting these many list boxes separately. they want only two list boxes year and month or hierarchy calendar list box that will apply to all date columns

This is the sample data and one of the major requirement from client

Massimo Grossi dushan chathuranga.

Please Help me out from this guys

Thank you in advance