Pie Chart Prior Month Results

Hello

On a screen I have two pie charts. One displays values for current month and the other I want display the totals for the prior month as a comparative to see how things are doing.

I want this to be dynamic, but I am having trouble with this.

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------

Find more posts tagged with

Accepted answers

All comments

Brendan Broughton

Hi @Jason Ferguson
The easiest way to show prior period (which will change as the screen select changes) is to select 'prior period value', or add a '-1' offset. You do this in the object Layout, select the required cube/block and then active/slide 'Time Functions' and in there you should see the options below.

If by 'comparison' you mean a change/movement, then you would just bring in two blocks, one current month, one prior month, then algorithm to find the difference and display that.

If that's not what you're after let me know.

------------------------------
Brendan
bbroughton@bi5.com.au
Australia
------------------------------
-------------------------------------------

Jason Ferguson

Hello Brendan

I had previously tried this but it is produce incorrect data. It seems to be doing days and the Calendar selection doesn't change offset type:

If is set it to -31 it gives me total of the prior month, but I believe that this could give incorrect data depending on the amount of days in the month.

The other pie chart that I have on the screen which I want to display current month data is giving the right data.

Cheers

------------------------------
Jason Ferguson
Management Accountant
Australia
------------------------------
-------------------------------------------

Brendan Broughton

Ah gotcha. Sorry, I assumed your cube was dimensioned by month. If you have it dimensioned by day then my solution won't work. I've never found a 'clean' way around that issue, day cube displayed as previous month

There are always workarounds, but if it was me I would just create a new cube dimensioned the same but swap out day for month. You then just need to populate it. If the day cube is populated by a datareader you could populate in there, or if it's by a procedure then I'd just dataflow from DAY to MONTH cube in there. Then just use the month cube for your charts.

------------------------------
Brendan
bbroughton@bi5.com.au
Australia
------------------------------
-------------------------------------------