Create X-Axis to Only Display Day over Several Months

Options
Stephanie_Price
Stephanie_Price Member
edited February 8 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:

Comments

  • GrantSmith
    GrantSmith Coach
    Options

    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!**
  • Stephanie_Price
    Stephanie_Price Member
    Options

    @GrantSmith Thank you - going to try this.

  • Stephanie_Price
    Stephanie_Price Member
    Options

    @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.

  • GrantSmith
    GrantSmith Coach
    Options
     
    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!**

Categories