8 Replies Latest reply on Dec 16, 2013 9:08 AM by Prolet Miteva

    Revenue and transactions based on frequency of visit

    Prolet Miteva

      Hi,

       

      I am trying to get some aggregate data for revenue and transactions based on number of visits. Ideally I would also like to be able to get this data by month or year. I tried one of the solutions posted in this thread: http://community.tableau.com/thread/121168 but I am having difficulties displaying aggregate data. right now the columns of the chart seem to be separated by user ID which can quickly become a challenge with larger set of data and it does not display the total for the particular segment.

       

      The data source looks something like this:

      UserIDDateTransactionsRevenue
      uid1201310100
      uid2201310115
      uid3201310100
      uid42013101245
      uid5201310100
      uid6201310100
      uid1201310500
      uid2201310700
      uid3201310418
      uid4201310300
      uid12013114113
      uid12013115123

       

      and I would like the result to be more like this:

      Number of occurrencesSum of TransactionsSum of Revenue
      100
      2458
      4236

       

      Attached are the excel file with sample data and my attempt in Tableau to show the data.

       

      Any help is really appreciated. I could not find any good solution browsing through the community forum.

       

      Thanks