Forum Discussion

datapal04's avatar
datapal04
Helper I
3 years ago
Solved

Adding Markers to Chart

Hello,

I have a bar chart that counts the number of cases our business unit receives. As an aside, we also have different Events (at any random day) which may influence the number of cases received. I'd like to have a marker (or some visual) to quickly identify when an Event occured. How would you suggest to go about this? Desired outcome is below (Event markers are in orange).

Thanks in advance for your help!

Need Help
Tips and Tricks
  • rsbin's avatar
    rsbin
    3 years ago

    datapal04 ,

    My suggestion is to use the Combo Clustered Line Chart.  This can be a 1 or 0 or actual Event Count.

    Create a measure to Count your Events.  Put this as your Line.  Something like this.

    Then you can change line stroke width to 0, and change the Marker per your requirement.

    Hope this gives you an idea to work with.

    Regards,

     

7 Replies

    • datapal04's avatar
      datapal04
      Helper I
      3 years ago

      Here you go. There 2 tables: cases by day and dates for Events.

       

      DateCase NumbersDayType
      2022-06-13 0:00180Weekday
      2022-06-14 0:00252Weekday
      2022-06-15 0:00269Weekday
      2022-06-16 0:00244Weekday
      2022-06-17 0:00269Weekday
      2022-06-18 0:00129Weekend
      2022-06-19 0:0096Weekend

       

      eventnameeventdate
      Event 12022-06-14
      Event 22022-10-19
  • Arul's avatar
    Arul
    Super User
    3 years ago

    datapal04 ,
    To achieve this you have to use line and stacked column chart and then in the Line y  axis you have to use event metrics, then you have to enable markers under marker section then reduce the line stroke under line properties.
    Now you may get the expects result.

    Thanks,

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    datapal04 ,

    My suggestion is to use the Combo Clustered Line Chart.  This can be a 1 or 0 or actual Event Count.

    Create a measure to Count your Events.  Put this as your Line.  Something like this.

    Then you can change line stroke width to 0, and change the Marker per your requirement.

    Hope this gives you an idea to work with.

    Regards,

     

    • datapal04's avatar
      datapal04
      Helper I
      3 years ago

      Thank you! I'm curious if there is a mehod to display the name of the event when a user hovers over a marker?

      • rsbin's avatar
        rsbin
        Community Champion
        3 years ago

        datapal04 ,

        Yes, you can use the Tooltip functionality.

        Drag the field or fields you want to display into the Tooltip well.

        Other option is to create a custom Tooltip Page.   Search Youtube and you will get all the info you need and much better explanation than I can do here.

        Regards,