Built an average formula

Hi,

i want to show the proportions of recruitments and resignations of a factory.
Additional I want to create an average line to the bars (recruitments and resignations), that shows the trend of the number of employees.

How do I have to create the formula?

Thanks

Michi

Michi,

Please check some of the example reports in our Demo account of how to create the lines of “incoming” and “outgoing” items over the time:
https://eazybi.com/accounts/1000/cubes/Issues/reports/42786-created-vs-resolved-issues
https://eazybi.com/accounts/1000/cubes/Issues/reports/50046-history-of-unresolved-issue-statuses

Those reports are just examples; the exact solution will depend on your data model and the outlook of the report you wish to achieve.

Kindly,
Janis, eazyBI support