Dimension_Score WIse Calculation

[deepanshuSh]

I am trying to create a table which contains the list of dimensions (Fields that I have) and the corresponding null count and other calculation in front of the name of the field. I am trying to understand to get the corresponding values as shown in the excel image above. This is just a glimpse, I have around 100 + fields that are needed to be done in this following manner. 

[williejacobs]

Hi @deepanshuSh 

Think you will be able to achieve this with something like "sum(if(isnull(customername),1,0))"

Alternatively I would suggest creating a summary table in your script, with the same type of formula, which should be quicker to set up.

[deepanshuSh]

Hi Jacobs, Thanku for the response, however, your suggestion doesn't work, I had solved it myself through a workaround using $Field and $Table.