10 Replies Latest reply on Jun 12, 2013 9:30 AM by Jonathan Drummey

# Time Series at granular level

Hi All

I have this fieild which has value like:

Event Name       Amount

X                         5

Y                          6

Z                          2

X                         1

Y                         7

Z                          9

I need to Plot the time sereis for the amount with days in the month.

So if i select "X" the time series amount total should be sum of all the amount.

If i Select "Y" the time series amount total should be sum of the amount for (Y+Z)

and If i select "Z" the time series amount total should be onle Z.

Thanks

Thanks Sid

• ###### 1. Re: Time Series at granular level

Nope that didn't work. BRB.

--Shawn

• ###### 2. Re: Time Series at granular level

Hi Shawn

Are you trying to say that it's not possible or you want more information around it?

Thanks

• ###### 3. Re: Time Series at granular level

Actually I'm saying that wasn't the solution that I first posted, (and deleted) and that it's harder than it looked at first glance. More info would be greatly appreciated especially in the form of a packaged workbook, -- as what the final viz is will affect how it's done.

--Shawn

• ###### 4. Re: Re: Time Series at granular level

Here you go Shawn.

So what i need is that in the time series the grand total of the amount should come like in the below manner:

IF i select X it should be the entire sum of X+Y+Z

If i select Y it should be the sum of Y+Z

If i select Z it should be Z.

PFA the sample workbook. Hope this helps.

Thanks

• ###### 5. Re: Re: Time Series at granular level

Siddhartha, this one's beyond both my time and brain today. Alex Kerin and Jonathan Drummey have been hanging around a bit today. Maybe they can give you a hand.

--Shawn

• ###### 6. Re: Re: Time Series at granular level

I'm out of time today as well...do you want only the Grand Total to reflect the logic or every column to also reflect that logic?

Jonathan

• ###### 7. Re: Time Series at granular level

Actually every column should refelect that logic and that should sum up to the grandtotal.

Thanks

Sid

• ###### 8. Re: Re: Time Series at granular level

See the attached. This is the easiest solution, using a parameter to do a row-level filter.

Jonathan

• ###### 9. Re: Time Series at granular level

Hi Jonathan

Thanks for the reply, but getting sum for X and Z is fine and its correct. But when you select Y its giving out wrong sum.

It should be actually the Sum of Y + Z which in this case is 114907 and in your calculation it comes out to be 106264.

and then i changed the case statement from

CASE [event Parameter]

WHEN "X" THEN SUM([amount])

WHEN "Y" THEN SUM(IF [event] == "X" OR [event] == "Y" THEN [amount] END)

WHEN "Z" THEN SUM(IF [event] == "Z" THEN [amount] END)

END

to

CASE [event Parameter]

WHEN "X" THEN SUM([amount])

WHEN "Y" THEN SUM(IF [event] == "Z" OR [event] == "Y" THEN [amount] END)

WHEN "Z" THEN SUM(IF [event] == "Z" THEN [amount] END)

END

and it worked.

Thanks

Sid