Morning all, I'm having some problems getting my head around a charting request that I have been presented with. Any help would be appreciated.
I have a simple chart.
X axis showing months of the year
Y axis showing revenue and target revenue.
I need to calculate the following conditions:
3 months in a row where the revenue is below target = Bad
and where
2 out of 3 months = Acceptable
To be honest I'm not sure where to start with this, each time I think of a starting position I think a few steps on and realise its a dead end.
Any help greatly appreciated.
Thanks
Bit of an update I have used the following to help identify where the revenue is below target.
1 data item created that has an if statement that returns 1 when the revenue is below target and 0 if not.
A second data item with the the following calculation
moving-total([Data Item],3) This provides a count for the last three rows, so I can use it to identify three in a row.
However I'm now faced with what to do at the beginng of the year for the first two months and secondly I'm still baffled as to how I cancalculate when two out of three months are below the target level. ??? ???
Any ideas?
What is the data source? Dimensional or relational?
Hi Paul,
Its relational but I think i may have cracked it.
for the two out of three months I'm using the calculation moving-total([Data Item],3 for report) between 2 and 3.
For the issue concerning the beginning of the year ensure that the query is not filtered by any date range. This then feeds a new query item whereby I filter the year that I wish to view with the correct counts returning.
A some what confusing post I will agree 100%