This content has been marked as final. Show 1 reply
I am not able to calculate the count of the dimension which would calculate the based on other condition value.Getting the following error:
"Cannot mix aggregate and non-aggregate arguments" Calculation Error
I am getting the error cannot mix with aggregate with non-aggregate functions using if expression.
I have 3 dimensions :Status,Dimension1,Dimension2(These are all string datatypes).
In the Status dimension it contain the values like null,Defect,Exceptions,etc
I want to show the two values(Defect per host,Vuln per host) in the line graph based on the Date.-->In the X-axis contain date and Y-axis-contain Values
Vuln per host==count(Dimension1)/count(Dimension2)
Defects per host:If Status='Defect' then count(dimension1)/count(dimension2).
I am able to displaying the Vuln per host,but not defect per host.If i place the filter like "Status=defect" it is impacting the Vuln per host value.
I have used IF,IIF FIXED,Set1,Group1 and ATTR function for this but i ma getting the null values and "Cannot mix aggregate and non-aggregate arguments" Calculation Error.
Thanks and Regards