Filtering data from a List box into Chart

[#1]

Hi

I have a Status selection Red, Green, Amber and wondered how I add this into filtering data when I already have a filter by status.

Example attached

Thanks

[vishsaggi · Accepted solution]

Do this in your last table in the script and use RAG Status as your status selections. Previously you are using a field not linked to your actual data sheet.

RAGStatusFilter:

LOAD

RAGFilter AS [RAG Status]

INLINE [

RAGFilter

'Green'

'Amber'

'Red'

];