Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Took me a while to confirm the results but yes that does the trick.
Many thanks.