ScottLeeds Member

@Tjjones did you figure this out? sorry it took me so long to respond. yes Entrata supplies the JSON and I can walk you through the steps to get it, if you still need assistance.

@jessdoe

@jessdoe that didn't work either

@jessdoe now it just populates whatever number I put in the parenthesis after sum

I hope I'm saying this correctly. The column I'm trying to use is a beast mode so it's not showing as an option. To put in the actual column name instead of the `Score` example you gave.

thanks, that didn't work for me, but this did

@marcel_luthi thanks! you make it look so easy, I got a calculation error

@MichelleH thank you. the rolling 7 days is working for us. we would also like to capture dates that are 7-14 days ago, or another way to look at it would be the week prior to the last 7 days. I can't figure out how to do that. Any thoughts? And your help is greatly appreciated.

@MichelleH thank you! do you know if there is a way to format it to be current day of the week, or prior week day instead of specific dates? this would help to automate it.

thank you both, that worked

Thanks @amehdad! Have you had any experience getting the Entrata connector setup into Domo? I can't figure out how to get the correct Report Filters in JSON format to get the connector setup.

@amehdad if using the connector, how often is the data updated in Domo? versus emailing the report, because that way the data only gets updated when the report is emailed and that is usually done automtically once a day, correct?