Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello, Beatrice!
Try to do the followin:
=Count({<Jahr={">2010 <2017"}, Action={">0"}>}Action)
Hi Sergej, thank for your reply.
Unfortunately that doesn't work.
Hm, the expression isn't correct or result is not what you want?
I get "all expressions disabled"
So, if you have a line chart try to use Jahr as Dimension and my offered expression as expression. Should work.
Hi,
Try
count({<Jahr - = {2011,2012,2013,2014,2015,2016}>}Action)
Is this not what you want?