Forum Discussion

datapal04's avatar
datapal04
Icon for Helper I rankHelper 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....
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,

     

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

datapal04 ,

Please share sample data.

Thanks,

  • datapal04's avatar
    datapal04
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper User
      3 years ago

      datapal04 ,

      try this,

      then,

      make line stroke to 0

      Thanks,