Skip to Content
avatar image
Former Member

Count Function Not Working

Hello All i have a problem in count function.

i have a table which is auto generated from Database. means online table.

i want to create a summary according to data in that table.

i need a count of a value which are same in some columns. As example given below.

This is auto generated table online. Ticket number has unique value.

i want to know to get a count of "Restored within Time" by "Severity" and Region.

i am using below formula.

=count([TicketNumber] Where ([RestoredWithInTime] ="Yes" And [Severity]="High" And [Region]="Central"))

In above formula it should give me a count like 2. but it is showing 0.

if i use only one condition then it works. like,

count([TicketNumber] Where ([RestoredWithInTime] ="Yes")

Or

=count([TicketNumber] Where ([Severity]="High"

it gives me accurate output. but if there is more than one condition then it shows only 0 count.

Formulas which i have used for this are...

=count([TicketNumber] Where ([RestoredWithInTime] ="Yes" And [Severity]="High" And [Region]="Central");Distinct)

=count([TicketNumber]) Where ([RestoredWithInTime] ="Yes" And [Severity]="High" And [Region]="Central") (It Shows #MULTIVALUE Error)

=sum(count([TicketNumber]) Where ([RestoredWithInTime] ="Yes" And [Severity]="High" And [Region]="Central"))

Is there anything related to measures or dimensions?

Thanks In Advance...

capture.jpg (24.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers