I'm trying to figure out how to create a widget to report weekly sales / contributions in Analytics. This is to put into the Pulse area for management to see. What I thought I could do is grab the data based on the Fiscal Week, but I can't figure out how to do it without having to go back and edit the widget each week for the current fiscal week of the year. I think I need a formula, but just not sure how to figure out the correct one. If I was writing in SQL, it would be a comparison of today's date against the fiscal week. Does anyone know how to do something similar in Analytics for a filter?
John Jakovich & Chris Wallingford do we have more technical documentation about the Sisense formula language?
David Judd I found this little bit of documentation over in the Sisence site. I see a Now() type function and some date calculation functions. This might help a bit.