Forum Discussion
24 Months Scatter Plot Graph
Hi naoki
You could add "date" in the "Play Axis" as this article suggested.
Or add "date" in "Axis", add "sales person" in "Legend" field.
There are 12 months a year, which 24 months do you mean? the last 24 months from the current months?
What is the Independent variable and Dependent variable of the corelation?
Best Regards
Maggie
The 24 months that I meant from the day that the sales person joined. It doesn't matter to me when do they join, what matters is when did they made the sales. So if a sales person had their first sales in his 3rd month, a dot will appear on the 3rd month.
Something like my graph here, I sort of managed to get the data to show for 24 months, however, I have yet to check for issues. As for the white line, it should be an average line that is preset by me, whereby i will be able to identify which sales person is performing below average and it needs to be as per what I drawn a growing line.