<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Median Time on Page in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297130#M2090</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Did you get an answer from Adobe on this?&amp;nbsp; I have same problem!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 07 Mar 2018 20:16:31 GMT</pubDate>
    <dc:creator>matt-gardner</dc:creator>
    <dc:date>2018-03-07T20:16:31Z</dc:date>
    <item>
      <title>Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297127#M2087</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I am trying to create this calculated metric using the median function in conjunction with time spent per visit, but it is not working. I get the same value all the way down the column, regardless of what date range or dimension i break it down by. I also tried using it with"total seconds spent" but got the same result. Any ideas?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Oct 2017 21:56:44 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297127#M2087</guid>
      <dc:creator>Praise_The_Sun</dc:creator>
      <dc:date>2017-10-25T21:56:44Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297128#M2088</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Shawn, can you give us some info on how you had the workspace set up? If you're able to provide enough info to where I can start with a blank workspace and work up to where I can clearly see all median values being the same, that would be the most ideal.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 27 Oct 2017 23:25:22 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297128#M2088</guid>
      <dc:creator>Gigazelle</dc:creator>
      <dc:date>2017-10-27T23:25:22Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297129#M2089</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi there, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;here is an image of how I set up the median time per visit metric. On the workspace, I tried this metric with multiple dimensions, such as last touch channel and referring domain. All of them have the same median time per visit going down the column.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="median time per visit.JPG"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/8270i93A21609ED41E2FA/image-size/large?v=v2&amp;amp;px=999" role="button" title="median time per visit.JPG" alt="median time per visit.JPG" /&gt;&lt;/span&gt;Attached is &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 01 Nov 2017 14:24:23 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297129#M2089</guid>
      <dc:creator>Praise_The_Sun</dc:creator>
      <dc:date>2017-11-01T14:24:23Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297130#M2090</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Did you get an answer from Adobe on this?&amp;nbsp; I have same problem!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 07 Mar 2018 20:16:31 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297130#M2090</guid>
      <dc:creator>matt-gardner</dc:creator>
      <dc:date>2018-03-07T20:16:31Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297131#M2091</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;OK - I figured out what is going on!&amp;nbsp; The way functions work is not how I expected (and others asking this and similar questions). &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Aggregate / Statistical functions are applied to the breakdown rows of data in the freeform table - as opposed to the raw data.&amp;nbsp; Here is a simple example.&amp;nbsp; You can see that the mean pageviews per visit column has the same value for all rows:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Screen Shot 2018-03-07 at 1.43.25 PM.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/8271iD61F89F17436E25D/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screen Shot 2018-03-07 at 1.43.25 PM.png" alt="Screen Shot 2018-03-07 at 1.43.25 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Pageviews per visit is defined like this:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Screen Shot 2018-03-07 at 1.45.41 PM.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/8272i5C48AAD018E7853D/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screen Shot 2018-03-07 at 1.45.41 PM.png" alt="Screen Shot 2018-03-07 at 1.45.41 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Mean pageviews per visit is defined like this (note it includes a function):&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="Screen Shot 2018-03-07 at 1.46.09 PM.png"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/8273i830F959EFF100F5B/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screen Shot 2018-03-07 at 1.46.09 PM.png" alt="Screen Shot 2018-03-07 at 1.46.09 PM.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Why does the mean function return 6.66 and why does the summary in the "Pageviews per Visits" column return 6.71?&lt;/P&gt;&lt;P&gt;6.66 is the average of the values in the "Pageviews per Visits" column - the average of 7 values.&amp;nbsp; That is how the Adobe functions work in calculated metrics.&amp;nbsp; The overall value in the "Pageviews per Visits" column is the total number of pageviews over the 7 days divided by the total number of visits over the 7 days.&amp;nbsp; The math for these helps you see why they are not the same thing:&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="RB 2018-03-07 16.48.41.jpg"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/8274i511FBC17A09222F6/image-size/large?v=v2&amp;amp;px=999" role="button" title="RB 2018-03-07 16.48.41.jpg" alt="RB 2018-03-07 16.48.41.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 07 Mar 2018 21:53:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297131#M2091</guid>
      <dc:creator>matt-gardner</dc:creator>
      <dc:date>2018-03-07T21:53:01Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297132#M2092</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Ok, but any idea on how to achieve original request?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 25 Sep 2019 21:58:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297132#M2092</guid>
      <dc:creator>alv123456</dc:creator>
      <dc:date>2019-09-25T21:58:59Z</dc:date>
    </item>
    <item>
      <title>Re: Median Time on Page</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297133#M2093</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Basic functions within Adobe Analytics fall into the categories of 'Row' or 'Table', its imperative to be mindful of which type you are trying to employ.&lt;/P&gt;&lt;H2 class="title" style="margin-top: 40px; font-weight: 300; font-size: 24px; font-family: 'Adobe Clean', sans-serif; color: #4b4b4b;"&gt;Table Functions versus Row Functions&lt;BR /&gt;&lt;SPAN style="color: #4b4b4b; font-family: 'Adobe Clean', sans-serif; font-size: 16px;"&gt;A table function is one where the output is the same for every row of the table. A row function is one where the output is different for every row of the table.&lt;/SPAN&gt;&lt;/H2&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Median is a 'Table' function.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Couple of ideas to get you close:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.) Use a cumulative custom metric to evaluate where historically the 50% of visit break point is - then create a calculated metric for % of visits that are that value or lower.&amp;nbsp; This will allow you to trend if there is a change.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2.) Use nested if formulas to achieve a bucketed version of the median metric.&amp;nbsp; Something like (if visits shorter than x divided by all visits is &amp;gt; .5 then x)&amp;nbsp; You will need a number of if statements and need to start with your lower bucket.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;There are a couple of screenshots in this tweet that provide direction.&lt;BR /&gt;&lt;A href="https://mobile.twitter.com/JimKultgen/status/990020683446054912/photo/2" title="https://mobile.twitter.com/JimKultgen/status/990020683446054912/photo/2"&gt;Twitter&lt;/A&gt; &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 27 Sep 2019 18:30:01 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/median-time-on-page/m-p/297133#M2093</guid>
      <dc:creator>fsakjlfdsakljfd</dc:creator>
      <dc:date>2019-09-27T18:30:01Z</dc:date>
    </item>
  </channel>
</rss>

