How can we help?

New post
0

Feature request: dates from comparison series in tooltip

Avatar
Erwin Manten
None
Follow

I use a lot of charts that compare last X days with the last X days before. So I get 2 series in 1 chart. But the tooltip always shows the date from the X-axis.

See example. The dates of last 28 days are used on the X-axis, the light blue line is the comparison, and contains older data (28 days prior to the last 28 days). But in the tooltip I keep seeing the value of the X-axis, in this example 'Jun 23'. It would be great to have the actual date here that matches the serie you hover. That way it also works in Analytics.

Date Votes

4 comments

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Erwin,

    Thanks for posting in our Community!

    Unfortunately, it is not possible to change the hover title of the X-Axis depending on the series you hover on.
    However, what you could do is change the X-Axis, so that instead of having the specific date, you just have "Day XX", where XX is 1-28.

    Or what you could do, is concatenate to two dates together in the X-Axis.
    Eg:
    June 23/May 25

    This could be done using the CONCAT function.

    Hope this helps!


    Best regards,
    Joshua
    _________________
    Joshua Cohen-Collier,
    Technical Support Specialist, Klipfolio

  • 0
    Avatar
    Erwin Manten

    Thanks for your reply! I would like to try the CONCAT function. I now use for the X-axis:

    datevalue(daterange(DATE_ADD( TODAY( ) , day, -28 ),YESTERDAY()), "yyyyMMdd")

    Is it possible to CONCAT that with the other range? ( today - 56 till today -28)

  • 0
    Avatar
    Josh Cohen-Collier

    Hi Edwin,

    Gotcha!

    Can you give this a shot?
    CONCAT(
    datevalue(daterange(DATE_ADD( TODAY( ) , "5", -28 ),YESTERDAY()), "MMM d"),
    "/",
    datevalue(daterange(DATE_ADD( TODAY( ) , "5", -56 ),DATE_ADD( TODAY( ) , "5", -29 )), "MMM d")
    )

    In related news, keep your eyes peeled, we've got something coming down the line that will definitely address this issue of the X-Axis!

    Warm regards,
    Joshua

  • 0
    Avatar
    Erwin Manten

    Thanks Josh! It doesn't work, but I will wait for that X-axis update you mentioned! :)

Please sign in to leave a comment.