Month over month comparison

user042524
user042524 Member
in Magic ETL

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 Coach

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

     

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user045772
    user045772 Member

    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 Coach

    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

     

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user045772
    user045772 Member

    Thanks, this solve my problem. 

     

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

Categories