Jump to content

Calculated Column Calculations


Shri G

Recommended Posts

Hi All,

I am new to spotfire and trying to created few calcumated coulmns to find count over columns. I have a below data and need to create few calculated columns.

Registration Number

Description

Reason

Update

2153

Ultra

FE

Available + In-Progress

4740

Scan

FE

Available + In-Progress

4980

Sonogram

FE

Available + In-Progress

1563

Scan

FE

Available + In-Progress

8254

Sonogram

FE-2

Available + In-Progress

5020

Scan

Queue

 

1260

Ultra

FE

Successful

1858

Nuclear

FE-1

Successful

4024

Sonogram

FE

Available + In-Progress

Need to calculate :

Total Cases : Count of all Registration Numbers over Description

Total Eligible Cases : Count of Registration Numbers over Description where reason is FE, FE1-1,FE-2

Eligible % : Total Cases / Total Eligible Cases *100

Total Successful Cases : Count of all Registration Numbers over Description where reason is FE, FE-1 and update is Successful

Available Cases : Count of all Registration Numbers over Description where update is Available + In-Progress

 

I have tried with OVER function to calculate total cases , but not able to create rest columns.

Count([Registarion Number]) OVER ([Description])

 

Can somebody please help me with this asap

 

Thanks,

Shri

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...