Calendar issue when using multiple reports
Hi all, I'm experiencing a bit of an issue with calendars on a dash, and would appreciate some suggestions or help.
I've got a source sheet for team-specific dates (let's call this source 1, although I have one for each team), and a source sheet for generic dates applicable to all (let's call this source 2).
Then, I've got a calendar on a team-specific dashboard that pulls from the report for source 1. I would like to add source 2 into the calendar report (for generic dates such as holidays and off days, so that I don't have to add the same info individually into each team calendar), but something's not working.
The calendar shows up perfectly on the dash as is with just source 1, and of course also when I add the generic days manually to the sheet that the report pulls from. However, when I add source 2 to the calendar report, the calendar shows entries from both source 1 and source 2 in my working window, but source 2 entries don't show up in either the preview or on the dash.
The columns are named the same, I've refreshed, I've re-published the calendar link and updated it on the dash, but no luck - source 2 items just aren't pulling through.
Could it be an access issue, if source 2 is in a different Workspace from source 1?