
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

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

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

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


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

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

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

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 rowlevel filter.
Jonathan

9. Re: Time Series at granular level
siddhartha.siddhartha Jun 11, 2013 9:14 AM (in response to Jonathan Drummey)
Hi JonathanThanks 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

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!