-
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 DrummeyJun 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 DrummeyJun 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
-
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 DrummeyJun 12, 2013 9:30 AM (in response to siddhartha.siddhartha)
Sorry about that, I'm glad you got it sorted out!