Hello everyone, how are you?
I am configuring a dashbord to calculate member within a spatial group, however, I have an error return when it is updating the New calculated member, I am using the following script
Aggregate(
Filter(
[Reporter].[User].Members,
CoalesceEmpty([Reporter].CurrentMember.get(‘Groups’), ‘’)
MATCHES ‘.(^|,)PSE($|,).’
)
)
so I am getting an error return (Print attached).
Can anyone help on how to improve this query?
Thank you
Welcome to eazyBI community!
The reason your report is facing a Timeout error is due to a large number of reporters.
I recommend you import Reporter Group as a dimension (Data from Jira). Once you have enabled Reporter Group import in your eazyBI report and imported your data into eazyBI, you can then add Reporter Group dimension on your Pages and filter the report by required Reporter Group.
Please let me know if you have further questions regarding this!
Kind regards,
Elita from support@eazybi.com
