Skip to content

    • Charting

    Charting

    Create X-Axis to Only Display Day over Several Months

    Member
    edited February 2024 in Charting
    image.png

    I am wanting to recreate the X-Axis here only showing days - then show changes MoM using lines.

    Ultimately, I want to create a filter that allows users to pick how many days they would like to go back and allow that to be compared.

    Any suggestions?

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Coach

      I’d recommend using a variable to allow users to input the number of days and use that in a beast mode to filter the card

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      @GrantSmith Thank you - going to try this.

    • Member

      @GrantSmith Any idea what this beastmode would look like? Not sure how the date field can be translated into days on the X-axis through using this.

    • Coach 
      1. CASE WHEN DATEDIFF(CURDATE(), `Date Field`) <= `Days Variable` THEN 'Include' ELSE 'Exclude' END
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories