CODEWITHSUNDEEP
tableau-api
JohnRambo
JohnRambo

Reputation: 23

Tableau - Multiple Line on Same Graph

I have a simple line graph with DATE on the X-Axis and PRODUCT on the Y-AXIS.

I have created a Parameter that gives the user ability to choose which PRODUCT to display on the line graph. However, I would like the user to be able to see more then one product on the graph, not just one. I would like them to be able to see multiple products on the same graph if they desire.

Right now there is only one line graph, even if they select multiple products. I would like them to all be displayed separately.

How would I do this?

Thanks!

Upvotes: 1

Views: 2867

Answers (1)

McClAnalytics
McClAnalytics

Reputation: 330

Drag your PRODUCT dimension from the Rows shelf to the color shelf (or detail shelf if you do not want each PRODUCT to be a differently colored line). Then add the desired measure to your rows shelf (like 'Number of Records' if thats what you want to measure). Then ensure that your graph type (options are above the color shelf) is still 'Line.'

This should ensure that the aggregate against your measure on your Y axis is calculated for each distinct PRODUCT dimension.

Additionally, on your X-axis you can use DATEPART() (for non-unique months, days, hours, etc) or DATETRUNC() (for unique months, days, hours, etc) to ensure that your aggregation against each measure is applied and graphed for each PRODUCT dimension accordingly (ie: you could have a node for each line plotted with the sum of every month, day, hour, etc).

Upvotes: 1

Related Questions