Hi Everyone,
I have a custom calender table and in my data tables I have multiple date fields.
I have created multiple relationships to the calender table with none of them set as active.
My questions is how can I have multiple visuals based on different date fields and have slicers work with accross the entire page.
To give more context, the main data table is a list of cases. I have a date the case was first recieved, date since last action, date case closed etc. I would like one visual to have a bar chart to show cases recieved 0-4 weeks ago, 5-8 weeks ago, 9-12 weeks etc. ans another visual should be similar but show number of weeks since the last action was carried out.
The date table works out the number of weeks and then I have another table with the week groupings, but I'm having trouble figuring out how to tell the visual which relationship to use. I am aware of USERELATIONSHIP but it doesn't seem to work with slicers and I'm not sure how to use it with the extra link to the grouping table. I would like to be able to slice the data by case worker, team, type of case etc. Perhaps I'm not using it right or need to make the relationships bi-directional?
Any example of how this should be achieved would be much appreciated.
TIA.
