11 Replies Latest reply: Jul 8, 2016 6:46 AM by Vineeth Pujari RSS

    How can I reference the values from Dimensions in set analysis?

    Sven Skottke

      Hi all,

       

      I was hoping to tap into your knowledge for help with this issue I'm having.

       

      What I'm trying to do is with set analysis measure the decline in user activity, using a log of transactions.

      The logic is that any user that completed a transaction last month and hasn't done any this month should be counted against the month they're missing from.

       

      To help, I've created a field called "LapseTransactionMonth". This field is the transaction created month forward-dated by 1 month.

       

      So, the basic code would be:

       

      //All users with transactions in the previous month

      Count({<LapseTransactionMonth = {"=CurrentMonth"}>} Distinct UserID) -

      //Subtract subset of users with transactions this month

      Count({<LapseTransactionMonth = {"=CurrentMonth"}, TransactionMonth = {"=(CurrentMonth)"} >} Distinct UserID)

       

      Note, CurrentMonth is meant to signify the month dimension on the visualisation; so if there are 7 months worth of data, this formula should be applied to each of them.

       

      Sofar, I've not been able to crack this.

       

      Thank you for your help.

       

      Sven