Distinct members in bar chart

1

Hi,

I have a Bar Chart that sum all the duration spent for each members on a specific task. When I have 2 members on the same task, it gives me an additional bar with the name of the 2 members as if it was a new member.
Is there a solution to make sure that the duration is affiliated to The 2 members instead of creating new one?

image
image1674Ă—1011 45 KB

1 Like
2

Hi @benoit_gramond, and welcome to this community! :slight_smile:

AFAIK, there are no obvious solutions for this.
If you find it useful, I created a simple example in order to “ungroup” your task owners in a different table: please, have a look:

However, I believe that this is just a workaround solution for a design that maybe needs to be re-thought?
In the end - from a Task perspective - you are multiplying durations of tasks for all the members that are working on.
This is one of the reasons why Task Management Systems usually have one owner (assignee) for each task.

Let me know if this makes sense.

Cheers

3

@benoit_gramond hi and welcome to the community!

I think you can do this by filtering the graph:

[Members].count()=1

4
  1. Introduce a table Members if there’s no already. If there is, skip to step 3.
  2. Use rows from Members to assign tasks to them instead of People.
  3. Look up events into each member’s row. Calculate what’s required (e.g. sum of session durations of linked events) into a column of the Members table
  4. Set up the chart based on the Members table, not the Events table
5

Great example @Paul_Danyliuk, :trophy:

Shedding a different perspective by being creative in the shema design :stars:

1 Like
6

@Federico_Stefanato Tanks a lot ! :slight_smile: Yes indeed, I usually track tasks with owners. The thing in that in this case it’s not possible.
Your solution is amazing!

1 Like
7

@Johg_Ananda thanks a lot ! I really need to have the time calculated. If I use that it simply delete the rows with more than one member right?

8

@Paul_Danyliuk thanks a lot, that sounds like the best solution!

9

@Jean_Pierre_Traets @Paul_Danyliuk yeah that’s true! thanks

10

@benoit_gramond it won’t delete the rows, but will not display them

1 Like