• State Not Answered
  • Replies 1 reply
  • Subscribers 38 subscribers
  • Views 17 views
  • Users 0 members are here
Options
Related

How to calculate the number of target languages per project in a report

Peter Johnston

I'm trying to create a dashboard to display the average number of target languages per project in a given timeframe.

As a basis for the dashboard to see if it was possible, I created a table, using the Projects dataset, with Project Name and Project Target Languages as Group By columns. I then added Project Target Languages again as a Value column thinking that it would count the number of target languages for a project but it just returns 1 for each project even if there's more than 1. I also tried changing it from Count to Count distinct but it made no difference.

If I use the File Translation Status or Task Status datasets, it seems to calculate the number of target languages as a sum of the number of languages per source file, which means it's way too high.

Any ideas as what I'm doing wrong?

Thanks

Peter

Removed AI Suggestion
[edited by: Peter Johnston at 10:43 AM (GMT 0) on 4 Dec 2025]
emoji
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0

    OK so update on this - managed to calculate the distinct number of target languages per project in a table by using the"Target English Name" datapoint from within the File Translation Status dataset and using it as a Value and changing it from count to count distinct. Now it shows the correct number of target languages per project.

    But now need to be able to calculate the average number of languages per project and display (as a KPI) but can't seem to get it to work

    I've tried a calculate field with the following but Quick Sight gives me an error that it doesn't like nesting of aggregate functions

    avg(distinct_count({Target English Name}))

    sum(distinct_count({Target English Name}))
    emoji
Reply
  • 0

    OK so update on this - managed to calculate the distinct number of target languages per project in a table by using the"Target English Name" datapoint from within the File Translation Status dataset and using it as a Value and changing it from count to count distinct. Now it shows the correct number of target languages per project.

    But now need to be able to calculate the average number of languages per project and display (as a KPI) but can't seem to get it to work

    I've tried a calculate field with the following but Quick Sight gives me an error that it doesn't like nesting of aggregate functions

    avg(distinct_count({Target English Name}))

    sum(distinct_count({Target English Name}))
    emoji
Children
No Data