• Home
• com.xresch
• cfw
• 10.0.0
• source code
• function_countif.html

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.xresch.cfw.features.query.manual.functions.function_countif.html Maven / Gradle / Ivy

This function is used to count number of records matching specified conditions. It supports aggregation and can be used in aggregation commands.

Following is an example how to use this function in aggregation commands:
| source random records=1000
| stats by=[LIKES_TIRAMISU] 
	# whenever the condition is true, count + 1
	COUNT_BIG=countif( VALUE >= 50 )
	COUNT_SMALL=countif( VALUE < 50 ) 
	COUNT_AURORA=countif( FIRSTNAME == "Aurora" ) 
	COUNT_HERA_BIG=countif( 
		FIRSTNAME == "Hera" 
		AND VALUE >= 50
	)
	COUNT_HERA_SMALL=countif( 
		FIRSTNAME == "Hera" 
		AND VALUE < 50
	)
| sort COUNT reverse=true


Following query creates random records and uses the countif-function. 
The count will be increased on records where the condition is met.
This can be useful for time based data to find out 'how many records up to this point have met the condition?'.
| source random records=1000
| set 
	#return a number that increases by 1 every call
	COUNT_ALL=countif(true)
	# return number that increase every time condition is true
	COUNT_NUMBERS=countif(VALUE > 50)