Aggregating from a previous field within a load script
Here's the first few lines of the table I am pulling my data from:
I would like to calculate what percent of total licenses are comprised of each product. For example, if I have 3,000 licenses for the product "Basic" and 10,000 licenses for all three products, then Basic would be 30% of consumer products. I need to use that 30% in other calculations.
I'm using the following to make a chart in my dashboard for expression "Percent Consumer". It works.
It's outputting a number, but it's the wrong number. I believe the reason for this is that "lookup" is only looking at one line in the table above. What I need is a way to sum up all the lookup values for a product. I tried using "sum" or "aggr" in conjunction with "lookup", but either that doesn't work or I'm doing it wrong.