-
1. Re: Slope Charts
Simon RuncSep 14, 2017 7:56 AM (in response to Rahul Singh)
hi Rahul,
So one way to do this is using LoDs...I created the following LoD calculation to work out the difference in profit from one year to the next (btw I've used MAX Year and MAX Year -1, with the Year Filter as context, so it will work with any 2 years selected)
[Profit +/-]
{FIXED [Sub-Category]: SUM(IIF([Order Date Year] = {MAX([Order Date Year])},[Profit],NULL))}
-
{FIXED [Sub-Category]: SUM(IIF([Order Date Year] = {MAX([Order Date Year])}-1,[Profit],NULL))}
I then bring this onto colour and set up as...
For my own indulgence I also added Year to size to get that extra feeling of direction!
There is also a way with Table Calcs, but it's more complicated (although less "hard coded")
Hope that helps
-
Colour Slope Charts.twbx 308.4 KB
-
-
2. Re: Slope Charts
Shinichiro MurakamiSep 14, 2017 8:04 AM (in response to Simon Runc)
2 of 2 people found this helpful -
3. Re: Slope Charts
Rahul Singh Sep 14, 2017 8:21 AM (in response to Shinichiro Murakami)Thanks a lot Shin and Simon.
I sometimes pity myself ,when will be I able to write such complex calculationsThanks again.
Cheers. -
4. Re: Slope Charts
Shinichiro MurakamiSep 14, 2017 8:24 AM (in response to Rahul Singh)
Hi Rahul
Don't worry.
Both Simon and I were lazy to skip the step by step formula creation, because we already knew answer for typical questions.
Actually the formula is long, but not so much "complex".
I hope you can break down the formula to 4 or more and you understand the steps/logic better.
Thanks,
Shin
-
-
6. Re: Slope Charts
Shinichiro MurakamiSep 14, 2017 8:50 AM (in response to Rahul Singh)
Rahul,
Good job.
It definitely works in this specific case.
Ours(LOD) will cover the case when you have 3 or more years and want to filter it to two.
Thanks,
Shin