Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Creating a visual based on a calculated group

Hello,

I have a dataset of customers and orders. I'd like to count how many orders each costumer has (this is dependant on the time frame end user has chosen) and then display a column chart of number of orders by amount. Eg, along x axis, 1 order, 2 orders, 3 orders. Y axis number of customers.

Could someone help please?
Need Help

12 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hello Anonymous 

     

    This is what I have tried to recreate your scenario:

     

    Sample Dataset:

     

    Visuals by customer & product:

     

    Is this what you are looking for? 

     

    If not, then please share more details on the requirement.

     

    Regards,
    Vivek

    If it helps, please mark it as a solution

    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey vivran22, thanks for replying.

      Based on your dataset, end result would be the following

      • vivran22's avatar
        vivran22
        Community Champion
        6 years ago

        Anonymous 

         

        Are you trying to create a frequency distribution chart (something like a histogram)?

         

         

        In this case, this is what I have come up with:

         

        Table =
SUMMARIZE (
    dtSales,
    dtSales[Order Quantity],
    "Customer Count", COUNTA ( dtSales[Customer Name] )
)

         

        Visual:

         

         

        pbix file

         

        Regards,
        Vivek

        If it helps, please mark it as a solution

        Kudos would be a cherry on the top 🙂

        https://www.vivran.in/