Count multi asset products

[vikasmahajan]

Dear Team,

I have excel like attached format  I have UserId,Products,Charge Month  3 columns in it , I want to show multiple asset products

like this

MultiAssetCheck:

LOAD user_sid , Product,charge_month

     Count(Product) as 'Multi Asset'

    Resident Asset

    Group By user_sid , Product,charge_month ;

Expected o/p

I want to count the multiple assets records and filter the same in pivot table with multiple asset details.

thanks in adv.

Vikas

[rajeshforqlikvi]

PFA,

Attached,

[jonathandienst]

I am not sure what your question is. If you mean you want to perform this count in the front end, then create a table with user_sid, and charge_month as dimensions, and Count(Product) or Count(Distinct Product) as the expression.

If you only want to see the dimensions when multiple products exist, then use something like

     =If(Count(Product) > 1, 1, 0)

and ensure that Suppress Zero Values is checked.

[vikasmahajan]

thanks for your reply ,

Requirement is like this :

I have text box as MultiAseet  when we click on text box , in pivot table we should able to see those records pertaining to multiaseet products , Now in pivot  i want to flag those assets , who are multiple by product,user_id  in each month

Urgent Please guide

Vikas

[settu_periasamy]

May be this >

=If(Aggr(Nodistinct Count(UseID)>1,UseID,charge_month),1)

[vikasmahajan]

Thanks Settu ,

I want to mark at script level can we use same formula in script and mark records as a multi asset , then using text box can i filter the same ?

Vikas

[vikasmahajan]

Awaiting for your reply urgent please ...

Vikas

[settu_periasamy · Accepted solution]

Yes. You can add the script like below

Left Join (MulAsset)

LOAD UseID,

  charge_month,

    Count(Product) as 'Multi Asset'

    Resident MulAsset Group By UseID ,charge_month ;

Check the Attachment..

[vikasmahajan]

Thanks Settu.

Vikas