4 Replies Latest reply: Sep 8, 2017 7:25 AM by Miguel Cunha RSS

    How to group dimension based on criteria

    Miguel Cunha

      Hello gyes,

       

      In a dashboard, I was asked to make a bar chart where to calculate the percentage of clients who visited my our stores at least once a week, monthly, or once every 3 months.

       

      Something like this:

       

       

      Basically, in terms of data, I have a table with all my clients (ID, Name, Subscribtion_date,...) and a table with all the transaction (TransID, Store, Client_ID, Product, Quantity, Value, Date).

       

      Maybe the title of this question is not correct but I dont know exactly what to ask.

       

      Can you please help me how to build the chart I want?

       

      Thanks in advance,

       

      Miguel Cunha