I have a Island Calendar I use to spread out along X axis. The problem having is I cant seem to take a group of records all having different time ranges and seeing if they fall within a time slot. Had no luck with the community searches.
Please help I plan to use the solution in many more charts.
If you want to use the Island Calendar Dimension in X axis then you need to join (link) the tables by specifying the common field in both the tables, then only you can use the Calendar Dimension.
Can you attach some sample data/file, it would be easier to understand.
ok, makes sense I need to link the calendar with main table that contains the dates.
The question I have is what date do I link the calendar to; the Create or Close date? or something else?
This makes sense why nothing was working. I think my other issue is since each period has many overlapping dates how do I get my expression to evaluate them for so they get summed correctly?
It seems this has been done but could not find any clear examples as of yet.
it really would help us understand your issue if you could post a small sample app or some input data.
In general, you have the option to use a data island calendar or create links between your calendar and the fact intervals.
The first approach creates a slim data model, but if you want to analyze your data, you need to use quite complex expressions that show not so good performance and needs more chart memory than with the second approach.
To create a data model that somehow links your calendar to the intervals, Henric posted some excellent tutorials here and here.
Your resulting table will have four fields, Id, CountOpps, DateType, Date.
Then you can link Date with your master calendar and use Date as dimension (or any field from the master calendar) and select the DateType in your expressions:
=sum({<DateType = {createDate} >} CountOpps)
=sum({<DateType = {CloseDate} >} CountOpps)
But it is all a little depending on what you want to analyze.
