COUNTIF_DISTINCT([ID], [Project] != 'OS')
Aggregation function returns the conditional distinct count of values.
field: Any existed data field within income data set.
logical expression: An expression that produces a Boolean value when evaluated, i.e. one of
FALSE. The combination of data fields, constants, text, numeric and date expressions with logical operators
>,<,>=, <=, != and etc. can be used to create logical expressions
Compare count of features which was improved by month. Row is counted only when the task was completed in more then 5 hours.
Time tracking stats for tasks of the building super hero suit
|Completed On||Task||Hours Spent||Feature|
|03 Jan 2018 10:13 AM||Create a steel helmet to protect head||19||Protective Suit|
|20 Jan 2018 04:08 PM||Create a chest protection from steel||45||Protective Suit|
|05 Feb 2018 11:34 AM||Ask agency to create fancy identity for new super hero||30||Design|
|09 Feb 2018 02:11 PM||Install super hero logo on body and helmet||2||Protective Suit|
|09 Feb 2018 02:11 PM||Put on gloves with nice color||2||Protective Suit|
|12 Feb 2018 09:01 PM||Ask Hulk to push in head||5||Combat Testing|
|01 Mar 2018 06:45 PM||Ask Hulk to push in chest||5||Combat Testing|
COUNTIF_DISTINCT([Feature], [Hours Spent] > 5)
|MONTH(Completed On)||COUNTIF_DISTINCT(Feature,Hours Spent > 5)|