1 2 Previous Next 16 Replies Latest reply on Jul 17, 2017 8:40 AM by Lydia Elias

    Concatenate count of date (integer) and a string?

    Lydia Elias

      I have two fields, [Date] and [Status]. I am trying to create a calculated field that has the count of days that each project is in different statuses.

       

      I was trying something like this, STR(COUNT([Date]))  + " of " + ([Status]) . But it is not working and it keeps saying I can't mix aggregate and non-aggregate arguments with this function. I am a bit new to Tableau so I am not sure what to do. I made it into a string because when I tried to just do the count of the date plus the status it said I could not combine an integer with a string. What is the correct way to create this calculated field?

        1 2 Previous Next