topic How to group and overlay graphs comparing different timestamp in Discussions

How to group and overlay graphs comparing different timestamp

sjaafar — Sun, 11 Jun 2023 11:17:28 GMT

Hi,

For simplification, I have three columns which are 'Year' (2019, 2020), 'Grade' (A, B, C) and 'Result'. My objective is to compare the results of Year 2020 vs Year 2019 by Grade, and I want to overlay them in Graph Builder so that I can see the comparison clearly between those 2 years. I would also like to group the data together and colour code them so that I can represent all of this in just one graph.

How can I approach this problem?

- Do I need to split the 'Year' column into two based on the Year?

*I have never used jmp before, so this is probably a simple question to many of you. Thanks a lot for your help :)

Re: How to group and overlay graphs comparing different timestamp

Thierry_S — Sun, 12 Sep 2021 16:25:11 GMT

Hi,

Welcome to the JMP User Community. First, your data is in the right format, just make sure that the "Year (2019, 2020)" column is set to Categorical or Ordinal if it is not already so.

Second, as a starting point in Graph Builder, I would assign your columns in the following roles:

Results = Y
Grade = X
Year (2019, 2020) = Overlay

You mentioned also including a color code but it is unclear on which variable you would like to base the color.

Also, I would strongly recommend that you explore the training material provided by JMP for Graph Builder, starting with the following:

https://www.jmp.com/en_us/learning-library/topics/graphical-displays-and-summaries/graph-builder.html

Best,