-
1. Re: Selected time period on trend line
khalid norat Nov 4, 2016 4:58 AM (in response to Gavin Attard)Hi Gavin,
There maybe a couple of ways of achieving this.
Is it possible for you to share your workbook and i can have a go at what you require.
-
2. Re: Selected time period on trend line
Norbert MaijoorNov 4, 2016 5:09 AM (in response to Gavin Attard)
-
Shading.twbx 1.2 MB
-
-
3. Re: Selected time period on trend line
Simon RuncNov 4, 2016 5:25 AM (in response to Gavin Attard)
hi Gavin,
Not sure if I've understood the requirements exactly!...however attached is my interpretation
I couldn't achieve the "Shading", but have created drop-lines (on selection) so it's clear what period of time is being compared.
Let me know if this is what you wanted, and if not why...if this does do the trick, post back here and I'll describe what I did.
-
Drop Lines for Selected Months.twbx 479.8 KB
-
-
4. Re: Selected time period on trend line
Gavin Attard Nov 4, 2016 5:47 AM (in response to Norbert Maijoor)Hi
I really like this solution and would work great if i didn't alreayd have 2 factors working on line colour (country and measure names...). So Close, but this would work for single line trend graphs. THANKS!
-
5. Re: Selected time period on trend line
Gavin Attard Nov 4, 2016 5:48 AM (in response to Simon Runc)Hi Simon
I ccouldnt find the time period filter used for the YoY calc. Am i missing something?
kr
-
6. Re: Selected time period on trend line
Simon RuncNov 4, 2016 5:54 AM (in response to Gavin Attard)
Ahh...so I did misunderstand!! - in my version, the time selector is done via an action. So if you drag-to-select some months on the TimeSeries chart it will create drop-lines for the selection, and show you the YoY for the selected Months in the variance bar chart.
...looks like Norbert's solution has done the trick though
-
7. Re: Selected time period on trend line
Norbert MaijoorNov 4, 2016 6:06 AM (in response to Gavin Attard)
-
Shading 2.twbx 1.2 MB
-
-
8. Re: Selected time period on trend line
Michael Hesser Nov 4, 2016 6:54 AM (in response to Gavin Attard)I'm going to follow Khalid's response!
Normally I would handle this by creating a two parameters which cover your [Start MY] and [End MY].
Once you have those, you'll be able to do a variety of tricks:
You can create a reference band that highlights the period in question.
Depending on you graph, you could change the color and or shape represented by data within the range.
Unfortunately, things could get a little problematic with the [End MY]. Parameters can be loaded initially, but they don't refresh. That means unless you load all your values into the parameters first, it won't show the latest. Bleah.
Another way around this (although admittedly sloppily), is this process:
- I created a little dimension called [Linker]. It's just a static value or number.
- I duplicated the data source, joining on [Linker] exclusively
- I added the date range to the filter and displayed it as a range
- I also added the MIN and MAX of this [Date Range] to details
- Once I did that, I had a lot of options! I decided to add a reference band, but you could just as easily create a formula and drop it into COLOR or SHAPE
-
Reference Band Range.twbx 1.2 MB
-
9. Re: Selected time period on trend line
Michael Hesser Nov 4, 2016 6:55 AM (in response to Gavin Attard)I love all these great responses!
-
10. Re: Selected time period on trend line
Gavin Attard Nov 7, 2016 4:18 AM (in response to Michael Hesser)Thanks for all the great responses guys. A few ways to try and get this done, appreciate your time, and expertise.
Michael, your answer is as close to what i had in mind. Will come back to you once i try and implement.
Thanks all!
-
11. Re: Selected time period on trend line
Gavin Attard Nov 7, 2016 8:07 AM (in response to Michael Hesser)So got the concept of this, and tried it out. the challenge i am finding is getting the field to follow a filter set from a different worksheet (within the same dashboard).
So i thought, ok, create a parameter as a common link between the two fields. However i am struggling to create a paramter that allows mulitple selection (i basically want to replicate a quick filter generated from MONTH(Date Field).
kr