Newbie, please excuse simple Q's... How can i group together multiple dates?

[emilyapril]

Eg, I have 100+ entries for dates of the month

01/01/2018 each with one of 3 responses.

and Id like to display all entries for each date as a total per date

so eg the chart to show

Date                    Result 1          Result 2          Result 3

01/01/2018           12                    87                  32

02/01/2018          11                    86                    19

Which would be the best table/chart to use and how would I put my request in to an expression or script?

Many thanks!

[Gysbert_Wassenaar · Accepted solution]

A straight table will do with Date as dimension and three expressions:

count({<response = {'Result 1'} >}Date)

count({<response = {'Result 2'} >}Date)

count({<response = {'Result 3'} >}Date)

Replace Date and response with the correct field names. And replace Result 1, Result 2 and Result 3 with the correct response values.

[passionate]

you can also use pivot table

use two dimension:

1. Date

2. Response

expression :

Sum(Value)

now shift reponse as header by draging on top (search this option in pivot table)