Net change of facebook followers in 30 day period

Reply
Welcome to Dojo

Net change of facebook followers in 30 day period

I am trying to make a calculated field which determines the net change in facebook followers in the last 30 days. The data has columns: 

example
Date: November 04, 2018 1:00:00 AM
Total Page Fans: 262
 
How can I determine the number of fans 30 days ago, and yesterday and output the difference for my card? I am very amateur at this logic so please try to be descriptive!
Red Belt

Re: Net change of facebook followers in 30 day period

I tried to step through this logic in an ETL for you.  I think that some of this is more complicated in ETL vs MySQL, but here goes.

 

a.png

 

There are four main steps.

 

Step 1: Assign a value for the date you want to compare to.  In your case, you mentioned 30 days prior and 1 day prior.  In ETL I used the "Date Operations Tile" to create two new fields, Date-30 and Date-1.

b.png

 

Step 2:  You need to join these dates to your original data set and then remove the duplicate (Date_1) field.

c.pngd.png

 

 

Step 3: Lookup the number of fans from 30 days ago and join that to your data.

e.pngf.png

 

Step 4:  Repeat step 3, but for one day ago.

 

g.pngh.png

Finish the ETL by attaching an output data set tile and naming your new data set.  

 

This will give you a data set with the following schema:

i.png

 

 

Good luck to you.  Let me know if you have questions.


______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________
Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!