Month over month comparison

I have a dataflow that returns the first day of the current month up to the current date and first day of the last month line up to the current date. The dates from the Dataflow are April 1, April 2, April 3, April 4, May 1, May 2, May 3, May 4.

Then I created cards and use the period over period.

Here's the screenshot:

 

Screen Shot 2020-05-05 at 1.49.43 PM.png

I compare it with last month(April).

I only want to show May 1 up to the current date (in these scenario May 1 to May 4) only. Also, I want to remove the sum data on May 31 I don't know why it is comparing May 31 and May 1 data. I'm stuck with this problem. Any help will be appreciated.

 

 

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    can you just filter to MonthToDate and add a previous period comparison?

     

  • Hello, I am using period over period and there is no month to date in date range. I also want to graph it by day. 

    Is there a function in beastmode that can remove remove May 31 or any calculation that can change the data showing in may 31? I'm so stuck with this. 

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤

    Interesting... i am able to see a Month To Date option under Bar Line that allows me to graph by day.

     

    If you're not having this experience, submit a support ticket with your CSM CC'ed maybe ask them to 'confirm if there's a feature switch missing that updates your analyzer experience'

     

     

    Capture.PNG

     

  • Thanks, this solve my problem. 

     

    By the way where is the *Accept as Solution*?