Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
we have data example:
Customer ID , Recharge Amount (ex. 5,10,15,20...................................)
I have some questions regarding this:
i wanted to find the the customers :-
who never recharge more than 5?
who recharge only once?
can anyone please help me in this?
Thank you.
Hello,
Perhaps this might help:
1. I have loaded a demo dataset:
2.Based on your requirement, you want to display:
3. You can create a Straight Table chart with CustomerID as dimension and for the RechargeAmount you can use the expression:
=IF(Aggr(NODISTINCT Sum(RechargeAmount), CustomerID)/Aggr(NODISTINCT Count(RechargeAmount), CustomerID) = 5, RechargeAmount, Null())
This expression counts the total sum of the RechargeAmount per customer and divide based on the total count of the RechargeAmount per customer. If the response is 5, then it means that all the RechargeAmounts were 5, otherwise if the response is a higher number, it means that at least on of the RechargeAmount values is higher than 5.
The outcome is:
4. You can also create a table that will that CustomerID as dimension and another dimension with expression:
=If(Aggr(NODISTINCT Count(RechargeAmount), CustomerID) = 1, RechargeAmount, Null())
This expression, counts the total amount of RechargeAmount values per customer and if the response is 1 then the particular customer had only 1 recharge.
The outcome is:
NOTE: For both occasions you will have to also un-check the option "Include null values"
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
Hello,
Perhaps this might help:
1. I have loaded a demo dataset:
2.Based on your requirement, you want to display:
3. You can create a Straight Table chart with CustomerID as dimension and for the RechargeAmount you can use the expression:
=IF(Aggr(NODISTINCT Sum(RechargeAmount), CustomerID)/Aggr(NODISTINCT Count(RechargeAmount), CustomerID) = 5, RechargeAmount, Null())
This expression counts the total sum of the RechargeAmount per customer and divide based on the total count of the RechargeAmount per customer. If the response is 5, then it means that all the RechargeAmounts were 5, otherwise if the response is a higher number, it means that at least on of the RechargeAmount values is higher than 5.
The outcome is:
4. You can also create a table that will that CustomerID as dimension and another dimension with expression:
=If(Aggr(NODISTINCT Count(RechargeAmount), CustomerID) = 1, RechargeAmount, Null())
This expression, counts the total amount of RechargeAmount values per customer and if the response is 1 then the particular customer had only 1 recharge.
The outcome is:
NOTE: For both occasions you will have to also un-check the option "Include null values"
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members.
It works @Andrei_Cusnir.......Thankyouuuuuuu