Expand my Community achievements bar.

Issue with visualizing line graph from filtered free form table

Avatar

Level 1

I have filters on a free form table and when I right click to create a line graph visualization, the numbers are completely off.

 

  • Line graph shows 22,000 people in August
  • Free form shows 850 people total in the entire data range. 

This is so frustrating to have to export this data and create visualizations in excel. Any advice would be appreciated. 

2 Replies

Avatar

Community Advisor and Adobe Champion

Based on your screenshot having the metric "people" I'm assuming you're using CJA and not Analysis Workspace? I've only used CJA a little bit, but I attempted to build something similar. I made a table and a line graph from it, and then did a filter on the table, but the line graph didn't change. So I was able to replicate the same issue that you're having. I tried the same thing in Analysis Workspace, and wasn't able to replicate it, the filter impacted the table and the line graph correctly.

 

I don't know enough about CJA to know if this is a bug or a feature. But given the fact that it doesn't do the same thing in Workspace, I think it's a bug. I would recommend sending in a ticket to client care, include screenshots of the table and graph both before and after adding the filter, to show that it isn't changing. Hopefully they can help you figure out what is happening. 

Avatar

Level 1

Yes this is CJA. I will certainly do that. On further review, I noticed that the total isn't even correct in the free form table. By the table's calculation, these pages total 850 people but the sum is actually 1,236 people.