Jump to content

SPOTFIRE: THEN Keyword in expression

Smita Vinayak Gayakude

Recommended Posts

This expression is probaly used in a visualization, right

UniqueCount(....) then [Value] / Sum([Value]) basically makes a count of unique values for every item on the X-axis and then devides this count by the sum of all unique counts. Like a normalization.

So let's say on the x axis you have A,B,C with unique counts of 2,3,1. Then it will devide everything by 6.

In the IF statement you check if the value/string in the column DocumentID is equal to "Not in VIM". The Trim function is just used to remove some useless spaces at the start or end of the string. (Some data can be messy...):

Trim(" trimmed ") -> "trimmed"

So if the condition is true you will make the unique count on the columnAccounting Document Number, if false on the columnDocument ID

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...