Better segment editor and fixes (#12040)

* column tweak

* fix install

* more tweaks

* rename column to dimension

* various fixes

* added new control expandable select

* starting to refactor segment selector

* make segment editor work again

* use translation keys

* defined some metrics

* set types

* simplify

* simplify

* fix join generator

* add possibility to use custom join table names when using query builder and it uses an inner query

* fix bug in query selector when selecting same field name from different tables twice

* more metadata

* more tweaks

* improve selector

* add possibility to use custom entity names

* also processed archived metrics

* generate sql filter, suggested values callback, and accept values automatically for columns with enums

* several tweaks

* focus search field when opening it

* various tweaks

* added missing method

* format and fix more metadata

* more fixes

* better definition

* define custom filter

* fix definition

* fix various tests

* fix more tests

* fix bug in logquery builder

* fix referrerurl segment was missing

* fix some tests

* fix more tests

* add group

* refactor for better definition

* fix a bug in log query builder when similar columns are used in archiver

* add goal metrics

* various fixes

* make datatable row more flexible

* various fixes and visualization enhancements

* simply segment editor and make it smaller

* remove trailing comma

* various fixes and added new dimension

* fix formatting of returning customer

* added missing primary key

* fixes

* various fixes and improvements

* make sure to update segment definition when selecting a value from auto complete list

* various fixes and more metrics

* more metrics

* more dimensions and fixes

* fix some tests

* fix some integration tests

* update submodule

* fix some system tests

* fix ui tests

* trigger new test run

* fix more ui tests

* fix system tests

* update submodule

* fix categories

* sort segments by category for more consistency

* add custom variables

* some translations and fixes

* add minute segment

* more segments

* added plurals

* added some docs

* fix test

* fix tests

* fix tests

* added suggested values

* fix some tests

* various fixes

* fix more tests

* allow to select segments on any site

* make sure to include file

* added doc block

* fix some system tests

* fix most system tests

* fix ui test

* fix system test

* adjust examples

* added more tests and docs

* no metrics for these dimensions

* added developer changelog and made some classes public api

* some fixes for entity names

* add possibility to set format metrics in test

* more consistency in defining the name

* get idsites only if provided

* fix integration tests

* added another segment for visit start hour and visit start minute

* more clear name for segment

* use old segment name to not break bc

* various fixes

* more test fixes

* fix no suggested values for new segment

* add event value

* for boolean dimensions only sum metric

* update available widgets when updating reporting menu

* Add new segments in developer changelog + typo

* fix system tests

* fix screenshot test

1 files changed, 27 insertions, 0 deletions

diff --git a/lang/en.json b/lang/en.json
index 0be70f5a08..1d1d5a332a 100644
--- a/lang/en.json
+++ b/lang/en.json
@@ -20,6 +20,7 @@
         "AverageOrderValue": "Average Order Value",
         "AveragePrice": "Average Price",
         "AverageQuantity": "Average Quantity",
+        "AverageX": "Avg. %s",
         "BackToPiwik": "Back to Piwik",
         "Broken": "Broken",
         "BrokenDownReportDocumentation": "It is broken down into various reports, which are displayed in sparklines at the bottom of the page. You can enlarge the graphs by clicking on the report you'd like to see.",
@@ -37,6 +38,7 @@
         "ColumnActionsPerVisit": "Actions per Visit",
         "ColumnActionsPerVisitDocumentation": "The average number of actions (page views, site searches, downloads or outlinks) that were performed during the visits.",
         "ColumnAverageGenerationTime": "Avg. generation time",
+        "ColumnViewsWithGenerationTime": "Pageviews with generation time",
         "ColumnAverageGenerationTimeDocumentation": "The average time it took to generate the page. This metric includes the time it took the server to generate the web page, plus the time it took for the visitor to download the response from the server. A lower 'Avg. generation time' means a faster website for your visitors!",
         "ColumnAverageTimeOnPage": "Avg. time on page",
         "ColumnAverageTimeOnPageDocumentation": "The average amount of time visitors spent on this page (only the page, not the entire website).",
@@ -56,8 +58,10 @@
         "ColumnExits": "Exits",
         "ColumnExitsDocumentation": "Number of visits that ended on this page.",
         "ColumnGenerationTime": "Generation time",
+        "ColumnPageGenerationTime": "Page Generation time",
         "ColumnKeyword": "Keyword",
         "ColumnLabel": "Label",
+        "ColumnHits": "Hits",
         "ColumnMaxActions": "Maximum actions in one visit",
         "ColumnNbActions": "Actions",
         "ColumnNbActionsDocumentation": "The number of actions performed by your visitors. Actions can be page views, internal site searches, downloads or outlinks.",
@@ -83,6 +87,23 @@
         "ColumnViewedAfterSearchDocumentation": "The number of times this Page was visited after a visitor did a search on your website, and clicked on this page in the search results.",
         "ColumnVisitDuration": "Visit Duration (in seconds)",
         "ColumnVisitsWithConversions": "Visits with Conversions",
+        "ComputedMetricAverage": "Avg. %1$s per %2$s",
+        "ComputedMetricAverageDocumentation": "Average value of \"%1$s\" per \"%2$s\".",
+        "ComputedMetricAverageShortDocumentation": "Average value of \"%1$s\".",
+        "ComputedMetricRate": "%s Rate",
+        "ComputedMetricRateDocumentation": "The ratio of \"%1$s\" out of all \"%2$s\".",
+        "ComputedMetricRateShortDocumentation": "The percentage of \"%1$s\".",
+        "ComputedMetricCountDocumentation": "The number of %s",
+        "ComputedMetricSum": "Total %s",
+        "ComputedMetricSumDocumentation": "The total number (sum) of %s",
+        "ComputedMetricMax": "Max %s",
+        "ComputedMetricMaxDocumentation": "The maximum value for %s",
+        "ComputedMetricMin": "Min %s",
+        "ComputedMetricMinDocumentation": "The minimum value for %s",
+        "ComputedMetricUniqueCount": "Unique %s",
+        "ComputedMetricUniqueCountDocumentation": "The unique number of %s",
+        "ComputedMetricCountWithValue": "Entries with %s",
+        "ComputedMetricCountWithValueDocumentation": "The number of entries that have a value set for %s",
         "ConfigFileIsNotWritable": "The Piwik configuration file %1$s is not writable, some of your changes might not be saved. %2$s Please change permissions of the config file to make it writable.",
         "Continue": "Continue",
         "ContinueToPiwik": "Continue to Piwik",
@@ -212,6 +233,7 @@
         "IP": "IP",
         "JsTrackingTag": "JavaScript Tracking Code",
         "Language": "Language",
+        "Languages": "Languages",
         "LastDays": "Last %s days (including today)",
         "LastDaysShort": "Last %s days",
         "LearnMore": "%1$slearn more%2$s",
@@ -245,6 +267,7 @@
         "NbSearches": "Number of Internal Searches",
         "NeedMoreHelp": "Need more help?",
         "Never": "Never",
+        "New": "New",
         "NewReportsWillBeProcessedByCron": "When Piwik archiving is not triggered by the browser, new reports will be processed by the crontab.",
         "NewUpdatePiwikX": "New Update: Piwik %s",
         "NewVisitor": "New Visitor",
@@ -387,6 +410,7 @@
         "Upload": "Upload",
         "UsePlusMinusIconsDocumentation": "Use the plus and minus icons on the left to navigate.",
         "UserId": "User ID",
+        "UserIds": "User IDs",
         "Username": "Username",
         "UseSMTPServerForEmail": "Use SMTP server for e-mail",
         "Value": "Value",
@@ -394,6 +418,7 @@
         "View": "View",
         "ViewDocumentationFor": "View documentation for %1$s",
         "Visit": "Visit",
+        "VisitId": "Visit ID",
         "VisitConvertedGoal": "Visit converted at least one Goal",
         "VisitConvertedGoalId": "Visit converted a specific Goal Id",
         "VisitConvertedNGoals": "Visit converted %s Goals",
@@ -401,10 +426,12 @@
         "Visitor": "Visitor",
         "VisitorID": "Visitor ID",
         "VisitorIP": "Visitor IP",
+        "VisitorIPs": "Visitor IPs",
         "Visitors": "Visitors",
         "VisitsWith": "Visits with %s",
         "VisitorSettings": "Visitor Settings",
         "VisitType": "Visit type",
+        "VisitTypes": "Visit types",
         "VisitTypeExample": "For example, to select all visitors who have returned to the website, including those who have bought something in their previous visits, the API request would contain %s",
         "Warning": "Warning",
         "Warnings": "Warnings",