Forum Discussion

pablopablo's avatar
pablopablo
Frequent Visitor
6 years ago
Solved

Line value points for each Column series

Hi, I have the following graph which displays attendance by room for specific times of the day. The purple line with dots is the sum of the staff required for that day by time. Is there a way that I can have a dot for each room rather than just for the time slot?

 

 

Here is a sample of my data

 

So at the moment my graph would show (from this picture) would show a total of 37 staff (sum of calc_headcount)

 

what i want it to show is 

6:15am - 3

6:30am - 3

....

8:45am - 9 (3+3+3) for the 3 records at 8:45am

 

Is this possible? So essentially a dot above each coloured column

 

 

 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, it think the line value in 'Line and cluster column chart' can not display by each 'Room' in this case.

    But i have a workaround:

    1)Create a new page as a tooltip:

    2)when you hover on one dot in line chart, it shows:

     

    Best Regards,

    Giotto Zhi

4 Replies

    • pablopablo's avatar
      pablopablo
      Frequent Visitor
      6 years ago

      This is just a field in the data set with numbers.

       

      So in the graph it is displayed as the line and it is using 'sum' to display the dots. So it is summing by time. Need it to some by room but still display the times along the x axis

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Community Support
        6 years ago

        Hi,

         

        According to your description, it think the line value in 'Line and cluster column chart' can not display by each 'Room' in this case.

        But i have a workaround:

        1)Create a new page as a tooltip:

        2)when you hover on one dot in line chart, it shows:

         

        Best Regards,

        Giotto Zhi