Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I@m collecting data direct from a spreadsheet sheet with several years of data entered with individual day lines
I want to show the last 6 months average value by consecutive month
I.e.
I have the Dimension “Downtime date” a daily date reference
I have a second dimension “log type" which separates the items into 4 categories to show by price
( I also have available “Downtime Month” or “Downtime year”
I have an expression AVG “invoice price”
Could you help me with the modifications to the expressions to pick up the "last" 6 months info as I only seem to be able to pick an individual years month and not run across 2 years
thanks
Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations
Hi,
Hope it will help u to complete u r task,
use straight table for this
dimensions : Downtime date,log type
In Expressions tab:
under Accumulation-> click on check box Accumulation -.> set steps back to 6
Expression : sum({<Downtime year={2015}>} invoice price)
Hope it will helps u.
Thanks and regards
Balaji.k
* INLINE [
college,name, score
?a, 1, 50
?a, 2, 60
?b, 3, 70
b, 4, 30
b, 5, 30
b, 6, 30
]
where Left(ltrim(college),1)='?';