<?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 Adding static number to a calculated metric based on day in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285948#M1809</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have serveral KPIs tracked via calculated metrics using segments &amp;amp; metrics&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We had a data outage April 24th to May 4th 2018&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I wish to add these missing values back&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example - Calculated Metric 1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Based on Segment Page starts with NAME A&amp;nbsp; visit based (ie not hit or visitor)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Metric = visits&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Attempt 1:&lt;/P&gt;&lt;P&gt;adding container using +&lt;/P&gt;&lt;P&gt;Dimension Day = April 24th&lt;/P&gt;&lt;P&gt;Static Number = 1111&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;FAILED: adds 1111 to all days not just April 24th&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Repeated using Segment based on April 24th&lt;/P&gt;&lt;P&gt;Failed : adds 1111 to all days&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Tried crating a calcul;ated metric seperaly for the day&lt;/P&gt;&lt;P&gt;Day=April 24th&lt;/P&gt;&lt;P&gt;Segment to id pages&lt;/P&gt;&lt;P&gt;PLUS&lt;/P&gt;&lt;P&gt;1111&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;ALSO failed&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any advice?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;&lt;P&gt;Sharon&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 18 Jun 2018 18:28:24 GMT</pubDate>
    <dc:creator>sharonf46201481</dc:creator>
    <dc:date>2018-06-18T18:28:24Z</dc:date>
    <item>
      <title>Adding static number to a calculated metric based on day</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285948#M1809</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have serveral KPIs tracked via calculated metrics using segments &amp;amp; metrics&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;We had a data outage April 24th to May 4th 2018&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I wish to add these missing values back&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Example - Calculated Metric 1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Based on Segment Page starts with NAME A&amp;nbsp; visit based (ie not hit or visitor)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Metric = visits&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Attempt 1:&lt;/P&gt;&lt;P&gt;adding container using +&lt;/P&gt;&lt;P&gt;Dimension Day = April 24th&lt;/P&gt;&lt;P&gt;Static Number = 1111&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;FAILED: adds 1111 to all days not just April 24th&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Repeated using Segment based on April 24th&lt;/P&gt;&lt;P&gt;Failed : adds 1111 to all days&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Tried crating a calcul;ated metric seperaly for the day&lt;/P&gt;&lt;P&gt;Day=April 24th&lt;/P&gt;&lt;P&gt;Segment to id pages&lt;/P&gt;&lt;P&gt;PLUS&lt;/P&gt;&lt;P&gt;1111&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;ALSO failed&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any advice?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;&lt;P&gt;Sharon&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 18 Jun 2018 18:28:24 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285948#M1809</guid>
      <dc:creator>sharonf46201481</dc:creator>
      <dc:date>2018-06-18T18:28:24Z</dc:date>
    </item>
    <item>
      <title>Re: Adding static number to a calculated metric based on day</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285949#M1810</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;two ideas to solve the data gap:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;create a new calculated metric with the formula „if hits of [day] greater than 0 then [yournumber] else...“ (just needs a of clause for every day with different number and the original meteic i. the final “else“&lt;/LI&gt;&lt;LI&gt;use the first idea from the blog post here: &lt;A href="https://www.blastam.com/blog/adobe-analytics-calculated-metrics" title="https://www.blastam.com/blog/adobe-analytics-calculated-metrics"&gt;3 Problems Solved by Adobe Analytics Calculated Metrics&lt;/A&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;hope that helps!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jun 2018 00:49:55 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285949#M1810</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-06-19T00:49:55Z</dc:date>
    </item>
    <item>
      <title>Re: Adding static number to a calculated metric based on day</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285950#M1811</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I think you may have a challenge here.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The key Metric is Visit(its a key variable as well as part of the calculated metric )&lt;/P&gt;&lt;P&gt;Since visits are a base metric unless you made them custom somehow as in some sort of SAINT association the data gap is exactly that a gap. You cannot fill it back in. We cannot report on data not collected. SAINT uploads may have some info you can upload but I have not done so myself when it comes to uploading (manually things like visits, pageviews, unique visits).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Also see data sources. they have some limitations but may help you in part.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_faq.html" title="https://marketing.adobe.com/resources/help/en_US/sc/datasources/datasrc_faq.html"&gt;Data Sources FAQ&lt;/A&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;GLTU&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jun 2018 14:56:16 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285950#M1811</guid>
      <dc:creator>Pablo_Childe</dc:creator>
      <dc:date>2018-06-19T14:56:16Z</dc:date>
    </item>
    <item>
      <title>Re: Adding static number to a calculated metric based on day</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285951#M1812</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks for your responce&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For this purpose assume I had no data populated in Adobe from March 2nd and to 7th &amp;amp; data stoped at 4pm March 1st&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I can get the zero data to populate &lt;/P&gt;&lt;P&gt;I planed created a calculated metric for each day &amp;amp; add to the primary KPI &lt;/P&gt;&lt;P&gt;The day for which I have partial data works fineie March 1st here I'm adding a static number to the existing visits to get a total &lt;/P&gt;&lt;P&gt;BUT in trying to get&amp;nbsp; the first day I had no data the following gets close &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;IF(logic_test,value_ifTrue, value_if False) &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Logical_test&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; EQUAL(metric_X,Metric_Y) -"Metric 1=Metric2"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Metric X =Segment (Pages of interest) Metric = Visits &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Metric Y= Static Value 0&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Value if True&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Static Value = 1111 &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Value if Falce&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Orginal Calculated Metric &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;This leaves the non missing data intact but populates all March 2nd to march 7th of missing data as 1111 &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Wraping any portion of the above in March 2nd changes nothing -in fact if I wrap the whole function in March 2nd ALL data populates as 1111 even non mising data days &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jun 2018 15:41:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285951#M1812</guid>
      <dc:creator>sharonf46201481</dc:creator>
      <dc:date>2018-06-19T15:41:10Z</dc:date>
    </item>
    <item>
      <title>Re: Adding static number to a calculated metric based on day</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285952#M1813</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;what happens if you slightly change your calculated formula: instead of using „equal“ try using „greater than“. then add your metricX as first parameter and the static number 0 as second parameter. and finally change the true/false values due to changed condition...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jun 2018 16:04:21 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/adding-static-number-to-a-calculated-metric-based-on-day/m-p/285952#M1813</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-06-19T16:04:21Z</dc:date>
    </item>
  </channel>
</rss>

