Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There, I'm trying to calculate relative percentages in a table. I'm looking at the NAICS groupings and trying to calculate the relative percentages of companies, based on a company_name field, and facility size, based on a facility_size field. So I need to sum all of the companies that belong to that specific industry, and then divide it by all of the companies across all industries. How might I do this? It needs to be general, as a filter on my dashboard will be industry groupings.
You can have a table:
As dimension: Indistry
as measure: count(company) / count({1} total company)