Set analysis for text object and stack charts seperately

[Anonymous]

Hi everyone,

I am trying to create stack charts with text object as summary KPI. The text object does not show the correct numbers as expected using the status selection on the top i.e GREEN being selection. The other dimensions are working fine.

1. Is there anything with expression used in the object?

    =num(Count ({$<[STATUS] = {'GREEN'}>} [STATUS])/Count ({$}[STATUS]),'###%')

2. Is there any workaround design to make both text object and stack chart work well together?

Regards,

Nelson