We have numerous databases set up in atlas using the same collections structure. I have a datalake set up which is combining each of those databases to query together in Charts. Which database a specific document originated from is important for analysis. I would like to use the data lake data source name as a variable for, say, Series variable on a bar chart.
I’ve tried using $collStats in a Charts data source pipeline, and setting up the data lake collections to be single collection per database as well as single data lake collection containing all of one collection type across all databases.
Is this possible?