Hi All,
I have fields :1) Activity Date1, 2)type Selected , 3)Date diff BW 1 to others calculated field and at filter
4) parent company code : I have selected some X ,Y & Z company codes
calculations used :
Date diff BW 1 to others :
DATEDIFF('day',(ATTR([Activity Date1])),([window date diff]))
where
window date diff :
LOOKUP(ATTR([Activity Date1]),1)
My requirement is to get aggregated each activity type value(date difference Between previous -current date value) based on parent company codes selected (any company code selection) with using activity date field in tableau visualization.
Now trying to use these calculation : it is getting error as ATTR function ..can I go with below calculation or any other calculations
to get the date difference value at visualization level :
{ INCLUDE [Activity Date1],[Parent Company Code1],[Activity Type: Selected1] : DATEDIFF('day',DATE(ATTR([Activity Date1])),DATE([window date diff]))}
I have attached sample screenshots. Please any one look in to these and do the needful.
Hello Srikanth,
Is it possible to share a sample workbook of the data. I'm unsure if the LOD calculation proposed would work without being able to look at the underlying data setup.
Thank you
Patrick
Become a Viz Whiz on the Forums! Support the Community and master Tableau.