Charts - two conditions in if-statement

[#1]

Hi,

I have to build many charts using different conditions, displayed side by side.
It works as long as I can use only one.

Data: 2014-2017

Dimension =if(match([Year], '2017'), Country)
Formula =sum(if(match([Year], '2017'), Duration))

I want to display only Year '2017' AND Color 'Red'

Cheers,

Chris

[sunny_talwar]

May be try this

Dimension

Country

Exp:

Sum({<Year = {2017}, Color = {'Red'}>}Duration)

[Anonymous]

In addition - If you want to untie the selected criteria: you need to do

SUM({1<Year = {2017}, Color = {'Red'}>} Duration)