Max date from multiple tables -


i new tableau. have found several answers here can't make them apply. may don't know enough yet. want max date show 1 time. have tried {fixed: max([date])} keeps giving me max date of entire table, not project title. have tried solution tableau community called max group_am , no avail. here screenshot of real data , results. created dummy sheet see if help. i've been working on off , on (mostly on)for 3 weeks. it's work , i'm stumped.format of tableau report.

cannot attach workbook. here's dummy data

name (name table task status (project closeout table) project title (project table) project sub code (project table) note (note table) insert date( note table) cool, dennis incomplete recreate support team tan-21622 project opened jan. 11, 2014 kartwright, laura incomplete accounts receivable tan-64500 project closed oct. 12, 2012 cool, dennis incomplete recreate support team tan-21622-4 project reopened april 1, 2015 kartwright, laura incomplete accounts receivable tan-64500 project closed feb. 28, 2012 cool, dennis incomplete recreate support team tan-21622-2 project closed march 14, 2014 kartwright, laura incomplete accounts receivable tan-64500 project cancelled june 30, 2012 cool, dennis incomplete recreate support team tan-21622-3 project closed sept. 10, 2015 kartwright, laura incomplete accounts receivable tan-64500-44 project closed april 30,2012 kartwright, laura incomplete accounts receivable tan-64500-6 project reopened june 12, 2012 faas, josh incomplete displaced workers roh-19566 project opened jan. 3, 2015 kartwright, laura incomplete accounts receivable tan-64500-44 project reopened april 1, 2012 faas, josh incomplete displaced workers roh-19566-1 project closed jan. 3, 2016 kartwright, laura incomplete accounts receivable tan-64500-45 project opened feb. 26, 2012

are using tableau desktop? edit calculated field group "project title".

{fixed [project title]: max([insert date])}

for more information around level of detail(lod) expressions have @ below link:

http://www.tableau.com/about/blog/lod-expressions


-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more