Just Pivot Your Data and Create Combined from Pivot Field Values.
If these are not already parameters, then create two parameters. Link the Start Date parameter to the Start Date field and link the End Date parameter to the End Date field. Create a field called filterDaterRange that looks like [start date]>=[startdateparam] and [end date]<=[enddateparam]. Drag this to the filter shelf and set it to TRUE.
Nope that did not work that was actually my first approach
I donot need a true and false filter...
I need a date range bar
You probably need to pivot the data source,
Anyways, if you could provide sample data as twbx format, we can assist you much easier.
str([startdate]) + " to " + str([wavesets_autowave_endtimestamp])
Right now am using this calculation just to see if i can form one range if line which i did..
but i need to jave the mentioned dates its there i am stuck
here is one problem
am using a custom SQL in my original dashboard..
And sql does not support pivot ..
I dont see pivot when i select these two fields
1 of 1 people found this helpful
Pivot using custom SQL
You can also use custom SQL to pivot your data. When you use the UNION ALL operator in a custom SQL query, you can take values from distinct columns and put them into a new column.
For example, suppose you have a table called Contest.
Runner Start Time End Time Amanda 9/3/2016 3:04 PM 9/3/2016 3:25 PM Oscar 9/3/2016 3:04 PM 9/3/2016 3:21 PM William 9/3/2016 3:04 PM 9/3/2016 3:16 PM
To optimize your analysis of this data in Tableau, you can use the following custom SQL query to pivot the "Start Time" and "End Time" columns so that their values are in a single column.
, 'Start' as [Action]
, [Start Time] as [Time]
, 'End' as [Action]
, [End Time] as [Time]
The above custom SQL query does the following:
- Pivots the Start Time column header into a string value called Start and adds that value to a new column called Action.
- Pivots the End Time column header into a string value called End and adds that value to a new column called Action.
- Pivots the Start Time and End Time columns so that their values are in a new column called Time.
The following table shows the results of this custom SQL query.
Runner Action Time Amanda
9/3/2016 3:04 PM Oscar Start 9/3/2016 3:04 PM William Start 9/3/2016 3:04 PM Amanda End 9/3/2016 3:25 PM Oscar End 9/3/2016 3:21 PM William End 9/3/2016 3:16 PM
Could you also create an extract and then pivot the extract? Never tried it, just wondering.
Sent from the iPhone of Timothy Dines.
I don't understand what you asked.
Without original connection, whatever I do does not make sense to you.
I never did a pivot on sql..
Does this require a whole new custom query for pivot ?
What the start for all this please lemme know
I got this..
Gotta make a whole new query with pivot and my table content required for visualization