Dear Tableau lovers,
Could you please help me in Solving my below issue.
Issue: I have three different graphs in my real time scenario and all graphs contain fixed reference Line in different Time Zone say 2 AM 5 AM and 8 AM. As per my requirement I want to see only those part of the Viz which lies above the Reference Line.Is there any dynamic way to achieve this case because in my Viz , there are three Reference Line at different Time Interval.Please provide me some workaround.
Note : I am using Tableau 8.3 Version
Additional Question:( This Question is Nowhere Related to above mentioned Question,its only For my curiosity and Knowledge. I can start a New Thread if it is required)
Question: I want to add a extra row at the end which will contain only NULL as a value. How can I achieve this ?
Product NameProduct IDOrder IDCurrencyProduct 11000$65.56Product 21015$2.77Product 310210$98.34Product 410315$31.68Product 510420$14.64Product 610525$32.24
Expected output
Rajeev,
You can do this with a parameter(s). But keep in mind though, currently parameters are not dynamic within Tableau, so new addition of data will need to be updated manually in the parameters that you create.
But basically you can create 2 parameters by calling your 'snapshot' datefield in the add from field menu in the parameter window. Click on 'show parameter control' for both of those parameters and place both of them on the detail shelf so that they are activated for use when you create reference lines:
You can create a reference band like how you would normally create but this time by setting it from parameter value 1 to parameter value 2.
You can create a calc like below to only display the area of interest:
Pooja.
