$\backslash$table$[[$Port Number,$\backslash$table$[[$Total number of$],[$cells$]],$Identified cells,$\%$ Identified$],[45,537,365,67\mathrm{.}97],[105,400,128,32\mathrm{.}00],[788,378,143,37\mathrm{.}83],[5357,537,234,43\mathrm{.}58],[12344,500,456,91\mathrm{.}20],[344654,445,100,22\mathrm{.}47],[454544,537,500,93\mathrm{.}11],[454545,875,345,39\mathrm{.}43]]$

Here,

Total Number of Port: $8$

$\%$ Identified

Question: $1$

a$)$ What is an aggregate function?

b$)$ How aggregations are constructed

c$)$ See above table and find how to get a count on the $\%$identified

Hints for question $($c$)$:

$$ Create a excel sheet with the above information and connect the data source with tableau. Drag the required excel sheet in the canvas and go to the worksheet. Click on the data panel in tableau if it is not selected. Right click somewhere there and click on create calculate field. Give the calculated field name as your wish. Just underneath it$,$ write the below function $($try to understand what the function is doing$).$

COUNT $($IF $[\%$ Identified$]<mtext></mtext><mn>5</mn><mn>0</mn>$

THEN $1$

END

$)$

$$ Click on apply and ok$.$

$$ Drag the new field to column and see the count values. Make a screenshot of it$.$