Hoping to duplicate a chart but be specific to each neighbourhood.
On the attached app you will see we have created 2 charts on 'sheet 2'. This currently shows the results based on the filter on first tab, however, we were hopig to create additonal charts that just show results for each neighbourhood so they are permanenlty on the app.
On the 1st chart - pie chart entitled 'Project Title -Eccles and Weaste' we have the following expression which enables the data to be presented in %'s. This is great but we want this chart just to show results from the neighbourhood 'Eccles and Weaste' - this expression doesn't do this...can you help?
On the 2nd chart - bar chart entitled 'Time (hours)' we have the following expression which enables the data to be presented in a simple bar chart. This is great but we again want this chart just to show results from the neighbourhood 'Eccles and Weaste' - this expression doesn't do this...can you help?
([Time (decimal hours)])
Eccles and Weaste is a neighbouhood, with list available on the main tab.
