Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
We can leverage filters to even change the field we are grouping by! This technique allows users to effectively see many different analyses, all in one query.

Below we have a query looking into the number of users by month for a fictional gaming company. Notice the [group_by] filter call in the select statement:
  , [group_by]
  , count(*)
group by
  , 2
Here is what our "group_by" filter looks like. 
To group by platform, we can select "platform" in our group by filter. Below are the results:
To group by source, select "source"
 The same applies for "gender."
Protip: You can call the filter in your chart title so the title can dynamically describe your filter selection!

That's three different analyses we were able to do by writing just one query! Creating group by filters is one of the many ways an end-user who is unfamiliar with SQL can dive into the dataset. 
Version history
Last update:
‎03-02-2023 09:30 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: