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

Time Series at granular level

siddhartha.siddhartha Jun 10, 2013 9:36 AM

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.

Please suggest.

Thanks

Thanks Sid

1. Re: Time Series at granular level

Shawn Wallwork Jun 10, 2013 9:49 AM (in response to siddhartha.siddhartha)

Nope that didn't work. BRB.

--Shawn
Like Show 0 Likes(0)

Actions
2. Re: Time Series at granular level

siddhartha.siddhartha Jun 10, 2013 9:53 AM (in response to Shawn Wallwork)

Hi Shawn

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

Thanks
Like Show 0 Likes(0)

Actions
3. Re: Time Series at granular level

Shawn Wallwork Jun 10, 2013 10:03 AM (in response to siddhartha.siddhartha)

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
Like Show 0 Likes(0)

Actions
4. Re: Re: Time Series at granular level

siddhartha.siddhartha Jun 10, 2013 11:09 AM (in response to Shawn Wallwork)
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

Sample.twbx.zip 18.3 KB
Like Show 0 Likes(0)

Actions
5. Re: Re: Time Series at granular level

Shawn Wallwork Jun 10, 2013 11:34 AM (in response to siddhartha.siddhartha)

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
Like Show 0 Likes(0)

Actions
6. Re: Re: Time Series at granular level

Jonathan Drummey Jun 10, 2013 12:01 PM (in response to Shawn Wallwork)

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
Like Show 0 Likes(0)

Actions
7. Re: Time Series at granular level

siddhartha.siddhartha Jun 10, 2013 12:09 PM (in response to Jonathan Drummey)

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

Thanks
Sid
Like Show 0 Likes(0)

Actions
8. Re: Re: Time Series at granular level

Jonathan Drummey Jun 10, 2013 4:18 PM (in response to siddhartha.siddhartha)
See the attached. This is the easiest solution, using a parameter to do a row-level filter.

Jonathan

parameter row level filter.twbx.zip 28.7 KB
Like Show 0 Likes(0)

Actions
9. Re: Time Series at granular level

siddhartha.siddhartha Jun 11, 2013 9:14 AM (in response to Jonathan Drummey)

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
Like Show 0 Likes(0)

Actions
10. Re: Time Series at granular level

Jonathan Drummey Jun 12, 2013 9:30 AM (in response to siddhartha.siddhartha)

Sorry about that, I'm glad you got it sorted out!
Like Show 0 Likes(0)

Actions