Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to calculate the 3 measures .
first measure perday total records count
Second measure Average per day
Third measure Total average on month
below is my data set:
how to show each date today records+previoustotalrecordscount?
how to calculate dynamically subtracting each day’s results from the previous day’s results by category.today records minus previous daytotalrecords.
adding each day’s “Per Day” count to the previous results and dividing by the number of days in the month
11/30/2020 | 3493912 | Avg/day/Month | |
12/1/2021 | 3495298 | ||
Per Day | 1,386 | 1,386 | |
Avg/Day/Mo | 1,386 | 1386/1 | |
12/2/2021 | 3,503,457 | ||
Per Day | 8,159 | 8159 | 1386+8159/2 |
Avg/Day/Mo | 4,773 | ||
12/3/2021 | 3,509,552 | ||
Per Day | 6,095 | 6095 | 1386+8159+6095/3 |
Avg/Day/Mo | 5,213 | ||
12/4/2021 | 3,509,552 | ||
Per Day | 0 | 0 | 1386+8159+6095/4 |
Avg/Day/Mo | 3,910 | ||
12/5/2021 | 3,509,552 | ||
Per Day | 0 | 0 | 1386+8159+6095/5 |
Avg/Day/Mo | 3,128 | ||
12/6/2021 | 3,521,631 | ||
Per Day | 12,079 | 12709 | 1386+8159+6095/6 |
Avg/Day/Mo | 4,620 | ||
12/7/2021 | 3,524,264 | 28,349 | total/30 days |
Total average per day |
Hi @MEDHA07 ,
Please use this formula.
rangesum(above(
num(Sum({$ <InvoiceDate={"$(='>=' & Date(MonthStart(Max(InvoiceDate)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max(InvoiceDate)), 'MM/DD/YYYY'))"}>}
sale),vCurr),0,RowNo()
))/max(day(InvoiceDate))