Data Blending Tableau

0
votes

I am creating a data blend and combining 2 excel files. I have volume
data dummy as primary data source & lifecycle dummy as secondary.
The common key is Ticket Id. Have created a calculated field to find the ticket
time which is Ticket Time =

DATEDIFF('day',ATTR([LifeCycle Dummy].[Assigned]),ATTR([LifeCycle Dummy].[Closed]))

Now i am not able to figure out how to show average ticket time per month or
at various other dimensions available such as priority, status etc. If i
remove the ticket id and only keep ticket time then the blend does not work. Do
advice if this can be achieved. Attached picture for reference.
tableau

1
tableau-api

1 Answers

1
votes

If you want to show average ticket time per month, or any data based calculation, you'll need to join the data sources on Date also - looking at your screenshot they don;t appear to be linked yet. To enable them to be linked both fields must have exactly the same name, then you can click the paperclip icon next to the field to link it.