Forum Discussion
Helper IScatter chart with hours as Y axis
HI, carlosflores
For the values on the Y-axis have to be aggregated, you need to add a "type" for your basic data to classify these Time.
for example:
assume that:
A representative When they get in.
B representative When they go to lunch
C representative When they come back from lunch
D representative When they leave for the day.
then drag the field type into Legend values
Result:
here is pbix, please try it.
https://www.dropbox.com/s/9rm7g2gpsivty6p/Scatter%20chart%20with%20hours%20as%20Y%20axis02.pbix?dl=0
Best Regards,
Lin
Helper Iv-lili6-msft, thaks for your response and sorry for the late reply,
It works but I haven't mentioned an important part of the problem. There are 4 times a day when people record attendance:
1. When they get in.
2. When they go to lunch
3. When they come back from lunch
4. When they leave for the day.
People should get in before 8:30, should go to lunch at 1, should get back from lunch at 2 and leave for the day at 18:00.
I'm using your method but I only see 1 dot per person, when there should be 4 per person (sometimes they don't mark the time, so there should be less dots for that person).
This is my data table
This is how it looks using your method:
As you can see, there's only one dot per person.
Thans again!
Community SupportHI, carlosflores
For the values on the Y-axis have to be aggregated, you need to add a "type" for your basic data to classify these Time.
for example:
assume that:
A representative When they get in.
B representative When they go to lunch
C representative When they come back from lunch
D representative When they leave for the day.
then drag the field type into Legend values
Result:
here is pbix, please try it.
https://www.dropbox.com/s/9rm7g2gpsivty6p/Scatter%20chart%20with%20hours%20as%20Y%20axis02.pbix?dl=0
Best Regards,
Lin
- carlosflores
v-lili6-msft YES! thank you, it works :')