Line Chart Time And Conditional Value

[rebelfox]

I have a table that has a month/year column and it has a single quantity column that holds a value that can be anything from 0 to 999.

I want one line on my chart to show the count of rows with a value of  0 over time.

The dimension is straight forward as it is a time dimension against a calendar.

The expression I am not clear how to code an expression to only count rows where the quantity column is 0.

Can anybody advise?

Thanks

[ziadm · Accepted solution]

use set Analysis is your expression

assuming this is your Table

Load * Inline [

Date, Quantity

01-05-2016, 1

01-05-2016, 0

02-05-2016, 0

03-05-2016, 1

03-05-2016, 0

];

in you line chart your dimension should be Date

and you expression should be

Count({<Quantity= {0} >} Date)

[rebelfox]

Took me a while to confirm the results but yes that does the trick.

Many thanks.