topic Re: How to create Adhoc reporting using field values in App Development

How to create Adhoc reporting using field values

Lakshmanudui — Wed, 18 Jan 2023 05:17:06 GMT

Hi All,

I am trying to create adhoc report using field values.

I have fields like Products, Category, Sub Category like that.

But Category field having 3 values like Office, Infrastructure and Material.

There is no separate dimensions for Category values.

My Requirement is if I select Products then show products data and If I select Category like Office then showing Office in Separate column and if i select Infrastructure then shown in separate column and Material also having same thing .

But Office, Infrastructure and Material there is no individual field.

I am trying to create Separate columns in Scripting side like using pick(Match)) Function.

Pick(Match(Category, 'Office'),'Office') as Office

Same thing i have created remaining values.

But it is not working properly. If i select Multiple selections in Category values then data won't be shown.

If I select single value it will work.

In the same way Sub Category also having multiple values.

Can you please suggest me how to achieve this scenario.

Thanks & Regards,

Lakshman

Re: How to create Adhoc reporting using field values

MayilVahanan — Wed, 18 Jan 2023 05:49:17 GMT

Instead of separate fieldname, create the individual expression by using set analysis and display it based on Conditional expression.

GetselectedCount( Category ) >0 and SubStringCount(Concat(Category,'|'),'Office')

Re: How to create Adhoc reporting using field values

Lakshmanudui — Wed, 18 Jan 2023 05:59:25 GMT

Hi Mayil Vahanan,

Thanks for your replay.

I am trying but single selections it will work, but Multiple selections it won't work.

If possible can you share example.

Thanks & Regards,

Lakshman