5 Replies Latest reply on Dec 10, 2013 4:00 AM by . Indumon

    percent of time taken against total

    Daniel Quattrucci

      I have three measures; Event Start Time, Event End Time and Event Duration. I'm attempting to calculate the percentage of time taken to complete all events against the total time. Total time is calculated by MAX(Event End Time)-MIN(Event Start Time). As such, Whenever, I true to get Tableau to calculate the percentage I get the message that I can't use both aggregated and non-aggregate measures in a calculated field.

       

      I'm kind of stumped. Other than extracting the data into Excel and doing the very simple calculation, before returning to Tableau I'm at a loss.

       

      Any thoughts would be appreciated.

       

      Ps. If this makes no sense please let me know.

       

      Kind Regards

       

      Dan