topic Re: Dimension_Score WIse Calculation in App Development

Dimension_Score WIse Calculation

deepanshuSh — Wed, 24 Aug 2022 10:25:27 GMT

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.

Re: Dimension_Score WIse Calculation

williejacobs — Wed, 07 Sep 2022 06:50:14 GMT

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.

Re: Dimension_Score WIse Calculation

deepanshuSh — Wed, 07 Sep 2022 15:50:20 GMT

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