Preparing Data for Infographics4 followers
I have a question about Infographics. I've seen many of the tutorials online, and maybe the answer exists out there somewhere, but I have been unable to find it. So I apologize if this is a moot question.
I have a large Workbook that I ran, filtering my data down to one state. (~798 mb total). I have several fields.
I created a Line chart for starters in the Infographic section of Datameer.
When I drag my Label, a date field, I can see that the Line Chart infographic updates with the appropriate dates along the Horizontal Axis. Similarly, when I drag my category variable, a string type, it looks like it draws a line for each.
However, when I pull one of my integer fields over to the Data box, it looks like Datameer displays only the first record from each point on the line chart. (I assume this because the value displayed is lower than I'd expect the aggregate to be, and the field has "(first)" next to it.)
Is there a way to change the aggregation of the Data box to a sum or average? Or do I complete this step earlier, by generating a pre-summarized Workbook Grouping BY, and Group-Summing by my respective charting fields?
Thanks very much for your help,