Need help to work with synthetic expression

Data management
1

Hi all,
I’m having a set of data(data for 3 months) and i would like to display the data as below,

  1. per day data in a widget
  2. per week(last 7 days) data in a widget
  3. per month(last 30/31 days) data in a widget

I’ve tried the “mean function”, “diff function” and the “last function”. But those functions doesn’t helped me out.
So could anyone help me on the above requirements?

2

Hi there, I do not understand your need, what do you expect to see when you say per day data in a widget? An average? a dot count?

I will be attentive