Skip to main content
Topics#Tableau Desktop & Web AuthoringPergunta de Emma Fan
Emma Fan (Callahan & Associates) perguntou em #Tableau Desktop & Web Authoring
11 de jul. de 2024, 20:51

Min(Date) of a User LOD + Filtering not showing some Users or their Min(Date)s.

In addition to the missing results, some of the Min Dates show up in the wrong order when I try to sort by Min Date descending.

Is there a way to fix one or both of these issues? I don't think my calculations are wrong, according to the internet.

Min(Date) of a User LOD + Filtering not showing some Users or their Min(Date)s.The 1st Visit field calculationthe conditions of the Attr(1st Visit) filterWhen I remove the original Date field from the rows, some users disappear even though their First Visit was indeed recent. 

When I have my Date of First Visit calculated field and the original Date field in the Rows panel, all users appear on the table

ECC.twbx
5 respostas
  1. Don Wise
    11 de jul. de 2024, 21:20

    You could use the following table calculation:

    IF FIRST()=0 THEN
    MIN([Date])=MIN([Date of 1st Visit to ECC]) END

    Which when placed onto Filters Card, then you'd right-click, select Edit Table Calculation and then set exactly as follows:

    You could use the following table calculation:IF FIRST()=0 THENMIN([Date])=MIN([Date of 1st Visit to ECC]) ENDWhich when placed onto Filters Card, then you'd right-click, select Edit Table CalculationThen right-click again, select Edit Filter, select True only. I removed all of the other filters which may have been contributing to some of the missing data, but you don't appear to have related data for quite a few locations:

    Screenshot 2024-07-11 at 2.10.55 PMThereafter, removed the sorts (cleared them all) then did a sort on Email using the Field Date of 1st Visit which then sorts the rows (emails) by oldest to most recent:

    Screenshot 2024-07-11 at 2.12.40 PMSo as to the missing locations (there are many!), you'll need to look at perhaps the joins and/or other related underlying data to determine why they're not appearing. Especially when all the filters have been removed, that would indicate to me where to look next. Unfortunately, we can't see the data source pane to show how things are related...sorry!

     

    Best, Don Wise -

    Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question. 

Escrever uma resposta...
0/9000