diff options
| author | Thomas Steur <tsteur@users.noreply.github.com> | 2019-10-22 06:55:53 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-10-22 06:55:53 +0300 |
| commit | 194a82021e781bcbeef35917c4a8d0f08ca71f0f (patch) | |
| tree | 7914c47636b4d03b2e4f187258577551d75c1c13 | |
| parent | 83096a6366adbe09b3333f87acd61d775fe20d75 (diff) | |
Fix server start time minute segment (#15034)
* Fix server start time minute segment
refs dev-1796
* fix test
| -rw-r--r-- | plugins/API/tests/System/expected/test_AutoSuggestAPITest_visitStartServerMinute__VisitsSummary.get_range.xml | 16 | ||||
| -rw-r--r-- | plugins/CoreHome/Columns/VisitFirstActionMinute.php | 4 |
2 files changed, 10 insertions, 10 deletions
diff --git a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_visitStartServerMinute__VisitsSummary.get_range.xml b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_visitStartServerMinute__VisitsSummary.get_range.xml index 9857cf3bdd..e0d7aff01a 100644 --- a/plugins/API/tests/System/expected/test_AutoSuggestAPITest_visitStartServerMinute__VisitsSummary.get_range.xml +++ b/plugins/API/tests/System/expected/test_AutoSuggestAPITest_visitStartServerMinute__VisitsSummary.get_range.xml @@ -1,12 +1,12 @@ <?xml version="1.0" encoding="utf-8" ?> <result> - <nb_visits>18</nb_visits> - <nb_actions>18</nb_actions> - <nb_visits_converted>18</nb_visits_converted> + <nb_visits>35</nb_visits> + <nb_actions>95</nb_actions> + <nb_visits_converted>35</nb_visits_converted> <bounce_count>18</bounce_count> - <sum_visit_length>8</sum_visit_length> - <max_actions>1</max_actions> - <bounce_rate>100%</bounce_rate> - <nb_actions_per_visit>1</nb_actions_per_visit> - <avg_time_on_site>0</avg_time_on_site> + <sum_visit_length>27579</sum_visit_length> + <max_actions>5</max_actions> + <bounce_rate>51%</bounce_rate> + <nb_actions_per_visit>2.7</nb_actions_per_visit> + <avg_time_on_site>788</avg_time_on_site> </result>
\ No newline at end of file diff --git a/plugins/CoreHome/Columns/VisitFirstActionMinute.php b/plugins/CoreHome/Columns/VisitFirstActionMinute.php index 545de365a8..9365886d56 100644 --- a/plugins/CoreHome/Columns/VisitFirstActionMinute.php +++ b/plugins/CoreHome/Columns/VisitFirstActionMinute.php @@ -20,7 +20,7 @@ class VisitFirstActionMinute extends VisitDimension protected $columnName = 'visit_first_action_time'; protected $type = self::TYPE_DATETIME; - protected $sqlSegment = 'HOUR(log_visit.visit_first_action_time)'; + protected $sqlSegment = 'MINUTE(log_visit.visit_first_action_time)'; protected $segmentName = 'visitStartServerMinute'; protected $acceptValues = '0, 1, 2, 3, ..., 56, 57, 58, 59'; protected $nameSingular = 'VisitTime_ColumnVisitStartServerMinute'; @@ -42,4 +42,4 @@ class VisitFirstActionMinute extends VisitDimension return $value; } -}
\ No newline at end of file +} |