Skip to main content

I have a target metric wherein I need to fetch all the project names assigned to a person within 12 months.
E.g. If the same project exists for multiple months in the source metric, in the target metric - it should return only the unique ones.

I tried this formula, this is working fine and returning all the projects assigned to each person in all the months.
But I want to fetch the unique projects.
Source Metric has dimensions: project, role, month
Target metric has dimensions: Project, role.

'Project Assigned'.Name[BY TEXTLIST: 'd. Month'][REMOVE TEXTLIST: 'd. Month']

 

Consider applying a rank function on the source metric to identify duplicates (where the rank > 1). Then create another metric where you filter out the duplicates. Finally, apply the textlist formula on the filtered metric.

Reply


Ask your question here!

Terms & ConditionsCookie settings