Forum Discussion

ce138867's avatar
ce138867
Resolver II
5 years ago
Solved

Compare Two Sets of Data In One Graph

I've got two separate sets of data and am trying to display them on one graph.  They have the same columns but am trying to compare the difference between the two as start set of data vs end set of d...
Need Help
  • ce138867's avatar
    ce138867
    5 years ago

    Not sure why my pics didn't display but I was able to figure this out. I had to create new tables specific to each item I wanted to look at. E.g. Gender table with a column with gender values that had relationship to each of the start and end tables that also had gender. This allowed me to pull gender as an axis value in my visuals and my values were measures of distinct counts of of IDs from my start and end tables. I continued doing this for other fields.  Not sure if this is the correct approach but it worked for me. 

     

     

ce138867's avatar
ce138867
Resolver II
5 years ago

Not sure why my pics didn't display but I was able to figure this out. I had to create new tables specific to each item I wanted to look at. E.g. Gender table with a column with gender values that had relationship to each of the start and end tables that also had gender. This allowed me to pull gender as an axis value in my visuals and my values were measures of distinct counts of of IDs from my start and end tables. I continued doing this for other fields.  Not sure if this is the correct approach but it worked for me.