2 Replies Latest reply: Nov 15, 2017 9:57 AM by Martin Pohl

Count if expression

stefan kollberg Nov 15, 2017 9:52 AM

Hi!

I have data in a table where I want to count nr. of Tickets where Source = 'Event' and present the result i a simple barchart.

I don't want to filter the data in the load script .

How can I create such an expression in Sense?

Re: Count if expression

Shraddha Gajare Nov 15, 2017 9:56 AM (in response to stefan kollberg)

Count(Distinct {<Source={'Event'}>}Ticket)
Like Show 0 Likes (0)

Actions
Re: Count if expression

Martin Pohl Nov 15, 2017 9:57 AM (in response to stefan kollberg)

Hi Stefan,

your expression is count({<source={Event}>} distinct Ticket)

maybe start_date is the Dimension of your bar chart.
Regards
Like Show 0 Likes (0)

Actions