Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Thank you for taking a look!
I'm looking for some assistance in a way to combine data from 2 master calendars into a single chart.
I've been unable to make any progress on it. 😞
Here is the tree;
Here is the first chart;
Dimension: MonthYear
Count({$<MonthEnd_Flag={"1"}>}Distinct([Person Number]))
Second Chart
Dimension: ReqMonthYear
Sum({$<ReqMonthEnd_Flag={"1"}>}[# Openings])
Any idea on how I could total both charts in a single chart? E.g. May 2019 should be 3183+309 = 3492
I would highly prefer not to remodel the data, as it is currently modeled to take advantage of the Hierarchy Functions. Trying to write the expressions for those was pretty tough in the first place. 😞
Thank you for any advice!
As usual some time away from the problem has allowed me to develop a solution.
I don't think this solution is a "clean" one, but it works. 😋
I simply duplicated the OpenReqs table, renamed all the fields and connected it to the original Master calendar, avoiding data loops by removing the other connections.
If anyone has a better suggestion, let me know!