Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Month on Month - % difference

Hi,    I have a series of facebook posts over a couple of years (by post date), including key stats - reach, impressions, engagement etc. - and am after some help creating month-on-month calculatio...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ross,

 

I think I'm getting a little closer... I tried the below formula instead to get previous month's figures but it's not returning any results... 

 

 any ideas?

 

Thanks again, 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Perhaps i didn't explain well.  [Post Count] wasn't supposed to be a field but an example of a measure.  What you need to do is a create a measure that performs your KPI, knowing that it doesn't handle the correct time constraint.  The calculate statement will run your measure and force in your applicable dates.

 

You will notice in my example I created the measure Post Count, which does a count of the number of rows in the data set.  The expectation here, for my example, was that each post would be a single row in the data.  Thus if I was to count my pretend data, i could get a count of all the posts in a given time period.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous

     

    Ok, I think I understand a little better now

     

    That being said, I'm still having trouble getting a formula to work... 

     

    I've created a column for 'average engagement rate' (=AVERAGE('POST DATA[ENGAGEMENT RATE]) ) and then have tried to apply the calculate statement to this but it still doesn't recognise it as a Measure. 

     

    Ideally, I'm wanting the average engagement rate for the current month vs the previous 

     

    Thanks again, and sorry for all the confusion

     

    Sonia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I noticed you said that you created a column for your Average.  That might be the problem.  A Measure and a Column are not the same things, although their buttons are next to each other. Try recreating that formula as a measure rather than a column

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Oh, great! yeah, i was usually a new column instead. I've now created the Average engagement as a Measure and was able to add it into the formula, but now I'm getting a 'circular dependency' error :(

     

    Am I using the right comulm from my Date table (DateKey)?

     

    Thanks again for all of your help

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    From afar this will be harder to diagnose, but you'll need to have a look at the 2 columns mentioned in the error.  Its likely this formula isn't the problem but is highlighting another issue.