Several conditionals on a total count

[shuck1985]

I have a line chart and I am plotting change in number of actions over several years

Now I want to exclude all actions that do not happen in that year. I did the following but that's not working (please note that Actions isn't the correct field name, I can't put the correct one here, hence the colour being wrong)

Could anyone help please?

[Sergey_Shuklin]

Hello, Beatrice!

Try to do the followin:

=Count({<Jahr={">2010 <2017"}, Action={">0"}>}Action)

[shuck1985]

Hi Sergej, thank for your reply.

Unfortunately that doesn't work.

[Sergey_Shuklin]

Hm, the expression isn't correct or result is not what you want?

[shuck1985]

I get  "all expressions disabled"

[Sergey_Shuklin]

So, if you have a line chart try to use Jahr as Dimension and my offered expression as expression. Should work.

[hcabrera]

Hi,

Try

count({<Jahr - = {2011,2012,2013,2014,2015,2016}>}Action)

[Sergey_Shuklin]

Is this not what you want?