Forum Discussion
Incorrect Values in Scatter Plot
Hi All, I have a requirement to show the count of ID as lables in Scatter Plot. I have created a column for the same but the values are not working as expected. The expected result for dept 2 is 2 ...
Anonymous - Thank you for the solution.
While testing, I noticed that the ID Table could not be joined with the Sal Table as the departments are not same in both these tables.
We will need to get the count of each dept from the ID table and not based on the dept from Sal table.
I added a new table "Owner" as per the requirement and joined with the ID table . Could you please help with the current design, I have updated the file here
Thank you.