[wp-meta] [Making WordPress.org] #4251: Don't count low/hidden priority strings toward translation percentage

[Making WordPress.org]

#4251: Don't count low/hidden priority strings toward translation percentage
--------------------------------------+---------------------
 Reporter:  Nao                       |       Owner:  (none)
     Type:  enhancement               |      Status:  new
 Priority:  normal                    |   Milestone:
Component:  Translate Site & Plugins  |  Resolution:
 Keywords:                            |
--------------------------------------+---------------------

Comment (by dd32):

 From a technical perspective, changing the completion % from being on all-
 string-in-project to subset-of-strings-in-project isn't going to be an
 easy (nor quick change).

 Due to the scale of Translate.WordPress.org we don't currently query these
 data points in a way that allows this change to be made easily.
 We cache the translation status of each project/locale in a custom table
 in the format of `project, locale, strings, translated, untranslated,
 waiting, etc` and calculate the % as `translated/strings*100`, but we
 don't include any data about the string priority counts.

 In order to add this, we'll have to breakdown the data further, for
 example including the breakdown of statuses:

 `project, locale, string_count, translated, untranslated...,
 string_count_high, translated_high, string_count_normal,
 translated_normal, string_count_low, translated_low`

 Given the size of the table (18.3million entries) we'd be better off
 summarising the data down even further though to the actual values we will
 have a use for, for example:
 `project, locale, string_count, translated, untranslated, ...
 completion_percent, completion_percent_ignoring_low_hidden_priority`
 (assuming we only care about overall completion_percent & percent ignoring
 low/hidden strings)

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/4251#comment:6>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org