Forum Discussion
Helper Icategorize customer
hi guys,
i have data like the below table
| customer | date | sale |
| x | 07/18/2022 | 23,000 $ |
| y | 07/15/2022 | 53,000 $ |
| z | 07/10/2022 | 36,000 $ |
| x | 02/22/2022 | 10,000 $ |
| z | 05/17/2022 | 23,000 $ |
i have 2 rule that i want to implement it:
if total sale of a customer is less than 55,000 $ then label it as A
else label it as B
and finally i want to have a chart that shows me how many percent of my customers is labeled as A and B
how can i achieve this?
thanks.
alisoroush7, yes it's possible.
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix
3 Replies
- SpartaBI
Community Champion
alisoroush7
Here is a link to download the file with the solution:
categorize customer 2022-07-20.pbix
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
alisoroush7thank you for your respons. with this code my request has been satisfied 80%.
i have another issue. the issue is that i have a date filter. for example month. when i filter my dashboard in a specific month, i want that code to consider only the chosen month data and label the customer based on a chosen month. for example it is possible that one customer is labeled A in July but it is labeled B in March.
- SpartaBI
alisoroush7, yes it's possible.
Please don't forget to accept the solution and will appreciate your Kudos on my solutions 🙂
Here is a link to download the file with the updated solution:
categorize customer 2022-07-20.pbix