7 Replies Latest reply on Feb 2, 2012 2:15 PM by Tyler Martin

    Can't get the Last actual value of my dataset in Tableau, only a AVG, MAX, MIN etc.

      I have the following below data in a measure and want to display only the "Value" in the LAST row of the dataset as the value of the BAR.

      As new values come in, When the server/display refreshes, I want the LAST row's "Value" to be the one used for Display, by the BAR.

       

      Is this possible?

       

      Note: The last two numbers are the value, I changed it from 65 to 25 to 85 to 45 and so on.

      I want the value of my marker (ie Bar) to be 65, change to 25, to 85, to 45 in a DashBoard automatically, the update to the server is every minute.

       

      aaPSM_Calc_MaxSource aaValuePeriodEndTime aaValuePeriodStartTime PSMDimension_Bypassed Number of Records PSM_Calc_Max

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 7:55:00 AM 2/2/2012 7:54:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 7:56:00 AM 2/2/2012 7:55:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 7:57:00 AM 2/2/2012 7:56:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 7:58:00 AM 2/2/2012 7:57:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 7:59:00 AM 2/2/2012 7:58:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:00:00 AM 2/2/2012 7:59:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:01:00 AM 2/2/2012 8:00:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:02:00 AM 2/2/2012 8:01:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:03:00 AM 2/2/2012 8:02:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:04:00 AM 2/2/2012 8:03:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:05:00 AM 2/2/2012 8:04:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:06:00 AM 2/2/2012 8:05:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:07:00 AM 2/2/2012 8:06:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:08:00 AM 2/2/2012 8:07:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:09:00 AM 2/2/2012 8:08:00 AM  1 65

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:09:00 AM 2/2/2012 8:08:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:10:00 AM 2/2/2012 8:09:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:11:00 AM 2/2/2012 8:10:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:12:00 AM 2/2/2012 8:11:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:13:00 AM 2/2/2012 8:12:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:14:00 AM 2/2/2012 8:13:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:15:00 AM 2/2/2012 8:14:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:16:00 AM 2/2/2012 8:15:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:17:00 AM 2/2/2012 8:16:00 AM  1 25

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:17:00 AM 2/2/2012 8:16:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:18:00 AM 2/2/2012 8:17:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:19:00 AM 2/2/2012 8:18:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:20:00 AM 2/2/2012 8:19:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:21:00 AM 2/2/2012 8:20:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:22:00 AM 2/2/2012 8:21:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:23:00 AM 2/2/2012 8:22:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:24:00 AM 2/2/2012 8:23:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:25:00 AM 2/2/2012 8:24:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:26:00 AM 2/2/2012 8:25:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:27:00 AM 2/2/2012 8:26:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:28:00 AM 2/2/2012 8:27:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:29:00 AM 2/2/2012 8:28:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:30:00 AM 2/2/2012 8:29:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:31:00 AM 2/2/2012 8:30:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:32:00 AM 2/2/2012 8:31:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:33:00 AM 2/2/2012 8:32:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:34:00 AM 2/2/2012 8:33:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:35:00 AM 2/2/2012 8:34:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:36:00 AM 2/2/2012 8:35:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:37:00 AM 2/2/2012 8:36:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:38:00 AM 2/2/2012 8:37:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:39:00 AM 2/2/2012 8:38:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:40:00 AM 2/2/2012 8:39:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:41:00 AM 2/2/2012 8:40:00 AM  1 85

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:41:00 AM 2/2/2012 8:40:00 AM  1 45

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:42:00 AM 2/2/2012 8:41:00 AM  1 45

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:43:00 AM 2/2/2012 8:42:00 AM  1 45

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:44:00 AM 2/2/2012 8:43:00 AM  1 45

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:45:00 AM 2/2/2012 8:44:00 AM  1 45

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:45:00 AM 2/2/2012 8:44:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:46:00 AM 2/2/2012 8:45:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:47:00 AM 2/2/2012 8:46:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:48:00 AM 2/2/2012 8:47:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:49:00 AM 2/2/2012 8:48:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:50:00 AM 2/2/2012 8:49:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:51:00 AM 2/2/2012 8:50:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:52:00 AM 2/2/2012 8:51:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:53:00 AM 2/2/2012 8:52:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:54:00 AM 2/2/2012 8:53:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:55:00 AM 2/2/2012 8:54:00 AM  1 15

      PSMDataSource.[KPI_Plant_Bypassed_002.Value] 2/2/2012 8:56:00 AM 2/2/2012 8:55:00 AM  1 15