Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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)