Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have application number and application source= Retail and Web, here i need to show number of retail applications and number of web applications
may be this
count({<application source= {'Retail'}>}[application number])
count({<application source= {'Web'}>}[application number])
='No of Retail application '&count({<[application source]= {'Retail'}>}[application number])&' and No of web application '&'Count of Retail application '&count({<[application source]= {'Web'}>}[application number])
Show it in a Text Object
Sorry Arul it results Total number of applications
check above else post sample app
Hi Naresh,
Attach some sample data and your expected output so that it would be easier to understand and provide the solution.
Regards,
jagan.
HI,
I would say Arul is correct, like he suggested some demo data would be helpful.
All i can add is maybe use distinct.
Count({<application source = {'Web'}>}Distinct [Application Number])
Mark
Hi Naresh,
Try like this:
Expressions:
Retail Applications Expression : Count({<[application source]= {'Retail'}>}[application number])
Web Applications Expression : Count({<application source= {'Web'}>}[application number])
I hope it will useful for you.
Thanks
Divya
Hi Naresh,
use below syntax if Application Number is not unique
count({<application source = {'Retail'}>}Distinct [application number])
count({<application source = {'Web'}>}Distinct [application number])
else
count({<application source= {'Retail'}>}[application number])
count({<application source= {'Web'}>}[application number])
if the above is not what you are looking for,please be more specific of your requirement.
Regards
Neetha
Hi,
this is another way ,
Then keep totals mode for expression as Sum of rows,
HTH,
Hirish