Last Value
This applies to: Visual Data Discovery
The last value metric in data is the last value in all the data values for a field, sorted by the time attribute selected for the time bar. If the latest date and time for the time attribute is exactly the same in multiple records, the last value for the field is the maximum value of the field in the records with the latest date and time.
When a connector supports the last value feature, it determines and uses the last value of a selected field in the data.
Although many data stores implement a last value function, the Symphony data discoverylast value indicates that the last value in a given field collection can be loaded and used in a visual immediately.
Support for this feature by connector is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable
| Connector | Supported? |
|---|---|
| Amazon Redshift | Y |
| Amazon S3 | Y |
| Apache Drill | Y |
| Apache Phoenix | N |
| Apache Phoenix Query Server (QS) | N |
| Apache Solr | N |
| BigQuery | Y |
| Cloudera Impala | Y |
| Cloudera Search | N |
| Couchbase | N |
| Dremio | Y |
| Elasticsearch 7.0 | Y |
| Elasticsearch 8.0 | Y |
| File Upload | Y |
| HDFS | Y |
| Hive | Y |
| Jira | N |
| MemSQL | Y |
| Microsoft SQL Server | Y |
| MongoDB | N |
| MySQL | Y |
| Oracle | Y |
| PostgreSQL | Y |
| Python | Y |
| Real Time Sales | Y |
| Salesforce | N |
| SAP Hana | Y |
| SAP IQ | Y |
| Spark SQL | Y |
| Snowflake | Y |
| Teradata | Y |
| TIBCO DV | Y |
| Trino | Y |
| File Upload (Upload API) | Y |
| Vertica | Y |