You'd have to play around with it a little bit, but it might not be that difficult.
I might start with a WINDOW_MIN(), WINDOW_MAX() --- maybe MIN(), MAX() would work too, depending on the data. I'm not sure offhand the best way to draw the line. Maybe fake it by just using a reference line on the y-axis and set the axis using invisible x-axis reference lines at the the MIN(), MAX() values.
Do you have some sample data?
P.S. And more specifically to your question
I know it is very easy to display the avg, current, min and max values in the axis but I don't know whether it is possible to have dynamic axis for each row and also assign specific measure values. Any idea if there is a way?
I assume that you've tried just clicking the axis and selecting the option for independent axes ranges for each row / column.
Thank you very much for replying to the question so quickly.
Yes - I have tried clicking the axis and selecting the option for independent axes.
I have created a very small dataset. It only contains two different issuers and different risk dates with the 5Yspreads.
Please find attached the excel spreadsheet that should be used as a source.
TableauSample.xlsx 8.6 KB
I played around with it a little bit.
It still needs some work (a color legend, size tweaking, ...). But it doesn't require a single table calc!
- Found the MIN(), MAX(), AVG(), Current values
- Found the spread MIN-MAX
- Calculated the normalized MIN, MAX, ..., such that MIN was 0 and MAX was 1. The MIN/MAX normalized fields are not needed, but I left them in to verify the calcs.
- Created a line graph with
- A dummy y-axis and formatted the Zero Line (Format > Lines > Zero Lines) as the horizontal.
- Add AVG and Now normalized values as Measure Names / Measure Values
- Add the regular MIN/MAX/Avg as tool tips.
- Hide all of the grid lines, column and row dividers.
- Added sheets for Low and High, Max columns.
- Merged everything on a dashboard.
The math in step 3 is solving for two linear equations.
MIN*m + b = 0
MAX*m + b = 1
m = (1-0)/(MAX-MIN)
b = m*MIN
Bloomberg.twbx 63.5 KB
Sorry! silly me! just downloaded the version 8.1!
That is amazing! Seriously thanks a lot for this!
Will have to look into it with more detail but it is great.
No problem. let me know if you get stuck.
On Dec 20, 2013, at 14:25, Leticia Soroa <
I did it and It worked perfectly! Many thanks again
On Dec 20, 2013, at 18:12, Leticia Soroa <