Hello,
I am working on a paper for my university and I want to find on average how often does Trump post every day. However, I do not need the mean of all the data I have, but the mean of each day since 2016 (data is from 2016-2020). In other words, I want to make a new column in which each row shows the average posts on that day. Example below the image.![Date.png Date.png](https://community.jmp.com/t5/image/serverpage/image-id/28877iDE7A1223FCF65C03/image-size/large?v=v2&px=999)
Example:
2016.01.04 - 5 posts
2016.01.05 - 9 posts
2016.01.06 - 4 posts
Is this doable within JMP?
Another problem that I am facing is that I am not able to copy a column from a different data file and place it in another.
![Close.png Close.png](https://community.jmp.com/t5/image/serverpage/image-id/28878iEF104030507F27DF/image-size/large?v=v2&px=999)
It just shows points instead of numbers.
I know that I am asking about a lot, but I will be thankful if someone is able to help me out.