<?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: Counting number of Mondays for running month in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308926#M2298</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;So currently:&lt;/P&gt;&lt;P&gt;Yearly target: 100&lt;/P&gt;&lt;P&gt;Monthly multiplier (towards yearly goal): 0.1&lt;/P&gt;&lt;P&gt;Target for this month: 10&lt;/P&gt;&lt;P&gt;Number of each weekday in this month: 4 (February is easy)&lt;/P&gt;&lt;P&gt;Multipliers for each weekday:&lt;/P&gt;&lt;P&gt;Mon: 0.25&lt;/P&gt;&lt;P&gt;Tue: 0.25&lt;/P&gt;&lt;P&gt;Wed: 0.09&lt;/P&gt;&lt;P&gt;Thu:0.25&lt;/P&gt;&lt;P&gt;Fri: 0.04&lt;/P&gt;&lt;P&gt;Sat:0.06&lt;/P&gt;&lt;P&gt;Sun:0.06&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Monthly and weekday multiplier were calculated based on last year performance&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So my target for&lt;/P&gt;&lt;P&gt;1st of Feb (Friday) would be&lt;/P&gt;&lt;P&gt;100*0.1*(0.04/4) = 0.1&lt;/P&gt;&lt;P&gt;2nd of Feb (Saturday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.06/4) = 0.15&lt;/P&gt;&lt;P&gt;3rd of Feb (Sunday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.06/4) = 0.15&lt;/P&gt;&lt;P&gt;4th of Feb (Monday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;5th of Feb (Tuesday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;6th of Feb (Wednesday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.09/4) = 0.225&lt;/P&gt;&lt;P&gt;7th of Feb (Thursday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So the problem was that I cannot get the number of each weekday in a month dynamically.&lt;/P&gt;&lt;P&gt;COUNT only returns number of Mondays from the past. for example if date is 8th of Feb COUNT returns 1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any comments?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 14 Mar 2019 08:51:42 GMT</pubDate>
    <dc:creator>antti_nylund</dc:creator>
    <dc:date>2019-03-14T08:51:42Z</dc:date>
    <item>
      <title>Counting number of Mondays for running month</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308923#M2295</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm trying to get the number of Mondays in this month (February).&lt;/P&gt;&lt;P&gt;Today is the first Monday of Feb so any way I try I get value 1.&lt;/P&gt;&lt;P&gt;The goal would be to get value 4 which is the number of Mondays.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any ideas?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 04 Feb 2019 13:15:11 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308923#M2295</guid>
      <dc:creator>antti_nylund</dc:creator>
      <dc:date>2019-02-04T13:15:11Z</dc:date>
    </item>
    <item>
      <title>Re: Counting number of Mondays for running month</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308924#M2296</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm not sure I understand you question. Can you clarify what you're looking for and how you intend to use it in reporting?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 08 Feb 2019 01:09:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308924#M2296</guid>
      <dc:creator>Gigazelle</dc:creator>
      <dc:date>2019-02-08T01:09:58Z</dc:date>
    </item>
    <item>
      <title>Re: Counting number of Mondays for running month</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308925#M2297</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I would like to build a daily target. I have monthly target of 100%. Data indicates that in average Monday, Tuesday and Thursday deliver 25% of Monthly target each and the rest 25% is divided with the rest of the days. I calculated the average from 3 months and made sure that each weekday was present same amount of times.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Since amount of weekdays is changing by the month I cannot use static number like 4. If I use COUNT IF day=Monday function in early Feb it would give me 0 or 1 depending if there has already been 1 Monday.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So if I want to calculate target for all Mondays in Feb (before Feb is completed):&lt;/P&gt;&lt;P&gt;100%*0.25 / COUNT Mondays (in Feb this translates to 0.0625) but in April the number would be 0.05 since there are 5 Mondays in March.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Even though Adobe prints all dates from Feb it does not seem to be able to calculate how many Mondays there is going to be. Counting weekdays works fine if I calculate the target for January, but that kinda defeats the purpose.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have now resorted adding the number as a static value but if you guys have any suggestion I welcome them gladly.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 14 Feb 2019 13:15:07 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308925#M2297</guid>
      <dc:creator>antti_nylund</dc:creator>
      <dc:date>2019-02-14T13:15:07Z</dc:date>
    </item>
    <item>
      <title>Re: Counting number of Mondays for running month</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308926#M2298</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;So currently:&lt;/P&gt;&lt;P&gt;Yearly target: 100&lt;/P&gt;&lt;P&gt;Monthly multiplier (towards yearly goal): 0.1&lt;/P&gt;&lt;P&gt;Target for this month: 10&lt;/P&gt;&lt;P&gt;Number of each weekday in this month: 4 (February is easy)&lt;/P&gt;&lt;P&gt;Multipliers for each weekday:&lt;/P&gt;&lt;P&gt;Mon: 0.25&lt;/P&gt;&lt;P&gt;Tue: 0.25&lt;/P&gt;&lt;P&gt;Wed: 0.09&lt;/P&gt;&lt;P&gt;Thu:0.25&lt;/P&gt;&lt;P&gt;Fri: 0.04&lt;/P&gt;&lt;P&gt;Sat:0.06&lt;/P&gt;&lt;P&gt;Sun:0.06&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Monthly and weekday multiplier were calculated based on last year performance&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So my target for&lt;/P&gt;&lt;P&gt;1st of Feb (Friday) would be&lt;/P&gt;&lt;P&gt;100*0.1*(0.04/4) = 0.1&lt;/P&gt;&lt;P&gt;2nd of Feb (Saturday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.06/4) = 0.15&lt;/P&gt;&lt;P&gt;3rd of Feb (Sunday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.06/4) = 0.15&lt;/P&gt;&lt;P&gt;4th of Feb (Monday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;5th of Feb (Tuesday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;6th of Feb (Wednesday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.09/4) = 0.225&lt;/P&gt;&lt;P&gt;7th of Feb (Thursday)&lt;/P&gt;&lt;P&gt;100*0.1*(0.25/4) = 0.625&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So the problem was that I cannot get the number of each weekday in a month dynamically.&lt;/P&gt;&lt;P&gt;COUNT only returns number of Mondays from the past. for example if date is 8th of Feb COUNT returns 1&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any comments?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 14 Mar 2019 08:51:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308926#M2298</guid>
      <dc:creator>antti_nylund</dc:creator>
      <dc:date>2019-03-14T08:51:42Z</dc:date>
    </item>
    <item>
      <title>Re: Counting number of Mondays for running month</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308927#M2299</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;you can use "approximate count distinct" with a weekday segment to get the number of a certain werkday in a specific month. but this only works for past data since you need to have at least one hit on each weekday to coont agsinst...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I would do this in excel or any other tool outside of analytics...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If you want to use workspace (and calculated metrics) you might try to upload a metric for each day using data source. basically you could upload a metric value for each day which indicates the number of werkdays the month have... (would be 4 for each day in february...)&lt;/P&gt;&lt;P&gt;the drawback is, that you can't upload data for the future, you might need to upload every day.... (hope I'm not wrong with this statement...)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 14 Mar 2019 13:38:22 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/counting-number-of-mondays-for-running-month/m-p/308927#M2299</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2019-03-14T13:38:22Z</dc:date>
    </item>
  </channel>
</rss>

