Count if expression

[stekol61]

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?

[shraddha_g]

Count(Distinct {<Source={'Event'}>}Ticket)

[martinpohl · Accepted solution]

Hi Stefan,

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

maybe start_date is the Dimension of your bar chart.

Regards