Measure for sum doesn't work in MAQ Gantt Chart

[yuching_chang]

Hi, I created a @MAQSupport MAQ Gantt Chart and want to put a measure in data label to show the sum of total weeks

But as you can see from the below photo, there are 3 processes under "Cathode" and the sum of 3 processes should be 21, but it shows 22....while the numbers of each process are correct...the same happens to other parent categories too (for all the others, the sum is 1 plus the correct number)...

If I remove the processes and only show the parent categories, the number of sum turns out to be correct.

No idea how to correct the issue...Pls help!!! Many thanks

[yuching_chang · Accepted solution]

I've appraoched to MAQ support team, got their solution and tested. The solution goes well and they may publish to the marketplace afterwards!

[v-juanli-msft]

Hi @yuching_chang 

As tested, it is also wrong on my side.

please contact the owner of the custom visual for help: https://maqsoftware.com/contact

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yuching_chang]

Hi @v-juanli-msft 

thanks for helping test! I've emailed the owner and hope they can reply soon...

[Anonymous]

@yuching_chang 

You must use all the Categories that makes up the 21. I think it considers 1st value not sure though how it works, when I tried  it showed total number for particular date when I added all 3 categories (including date) in Category section.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Proud to be Datanaut!

[yuching_chang]

hi @Anonymous 

thanks for the help, but for my case, I already used all the categories...

There are 2 categories, 1 is material and 1 is process, and material is parent category, so I make the hierarchy layout. The exmaple from the photo, "Cathode" is in material category, and its 3 processes are in process category.

In the raw data, for "Cathode", I only have 3 processes and I created a measure to sum up the numbers of the weeks for each as the total time taken for "Cathode". As you've known, it should be 21, but it shows 22...