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