2-6D
0 (0 Likes / 0 Dislikes)
A common action you may need to do when doing your analysis
is you may need to group your fields together—
either group categories together because they're similar
or do some kind of aggregation along a measure or date.
So we have a great feature called grouping that you can do this with.
So for example if you have a category that you know
the two categories are very similar,
so you just want to look at them together,
you can choose—for example, I know all season
and extreme are highly related—so I just want to see them together.
I select the two I want to group together.
I right click and I select group.
And so what it does automatically is it takes the segment
that I was looking at and it groups them together.
So the two that I selected in one group
and everything else in the other.
But if, for example, I didn't want to see everything else
as an other group, I can go into the field bliss
where this new group was created and select edit group.
And then from here I can choose to include all the other things
as other groups or not.
And so when I remove that, I just hit okay.
And they're all now separated out into their own individual items
other than the two I grouped together.
And this field is just like any other field in your data set.
You can use it in charts and move it around
and use it however you want.
You can also choose to do some kind of aggregation
over measures or dates. So for example,
if I have this date field here in sales
and I want to look at the months for each date grouped together.
So I can go into the field, click group,
and I can choose that I want to bend this by the months.
You want to hit okay.
The new bend field is created for me in the field list.
And like I said, you can just use these in a chart.
So I can see that each of the months for 2015 are shown here.
And then I can just see my revenue across each of those months.
And I can just make that a nice little column chart.
So this is a really quick and easy way
that you can group or aggregate your data
on the fly when doing your analysis.