Now what i want to do is to make a diagram (bar chart / line chart). In bars i want to show in calendar weeks, how many tickets were started -> there i made an calculated dimension (WeekName(StartDate)) and so got for every calendar weeks the started tickets - in the formula i used a count to count the tickets.
Now what i want is to show in a line the average - how many tickets were started in average.
And if i select an emloyee i want to see these average for his role and if no employee is selected i want to see the average over all roles.
Sometime it is so, that over the year an employee can change his role - than i watn to see the average for both roles.
I used WeekName(StartDate) as Dimension an created 4 formulas .. one where i count the tickets and show the started tickets and 3 for every role where i divided the sum of tickets for each role trough the numbers of employee which are linked to the role.