topic Re: count of industry in App Development

count of industry

Rajareddy — Wed, 29 Sep 2021 08:26:20 GMT

in my table like

code, id, group, industry

0001 , ab , a , bpo

002, ac , c, it

0020 , tc , a , bpo

i want show for how many bpo industry show in ui and script level

thanks

raja

MayilVahanan — Wed, 29 Sep 2021 08:40:19 GMT

Try like below

Count({<industry = {'bpo'}>}distinct code)

or, you can count the id or group , it depends on ur requirement.

Rajareddy — Wed, 29 Sep 2021 09:00:55 GMT

i want show how many bpos and how many it industry count like

bpo 2

it 1

etc 2

MayilVahanan — Wed, 29 Sep 2021 09:20:37 GMT

Add Industry as Dim,

Measure: Count(Distinct code)

Rajareddy — Wed, 29 Sep 2021 10:02:10 GMT

it's possible to back end

MayilVahanan — Wed, 29 Sep 2021 10:14:35 GMT

Try like below

Load Dim, Count(Distinct code) as NoOfCode resident tablename group by Dim;