Hi all,
As far as I know there is no way to merge two Holistics datasets on a common key. Is this something the team have considered adding?
A common question from colleagues at different departments are on the format:
- What is the proportion of
filtered datatototal data? - What are the counts of
filtered datacompared to counts ofunfiltered dataover time?
User difficulty without requested feature:
Two separate widgets would need to be created separately side-to-side making it harder to directly compare data since it’s not in the same visualisation.
Developer difficulties to prepare desired dataset:
Likely need to create derived SQL-tables in Holistics, or create additional tables in our Data warehouse and import to Holistics. This is cumbersome and only a matter of time before another colleague asks for another set of filtered dataset which needs to be prepared.
A feature to merge two Dataset results in Holistics would allow for a self-service approach. Similar functionality found in Google’s Looker docs
If this is solved already I’d be thankful if you could point me in the right direction on how to approach it. 