WAVE - Date fields don't appear in the Lens ValueTable screen's Column menu when they are listed in the 'Right Fields' of an Augment
Trailblazer Community

WAVE - Date fields don't appear in the Lens ValueTable screen's Column menu when they are listed in the 'Right Fields' of an Augment

Analytics

Last updated 2021-04-06 ·Reference W-3998584 ·Reported By 0 users

Fixed - Summer '17 Patch 10.0

Summary
When a date field is listed in the 'Right Fields' parameter of an Augment transformation that date field is no longer listed in the values table column selector in the new lens explorer in Summer 17.

Repro
1. Create a Dataflow in the Summer 17 release which performs an Augment transformation that includes a date field in the 'Right Fields' section.

2. Open a lens as a Values Table and confirm the date field does not appear.

Workaround
The date field does not appear in the menu but it can be used in SAQL and Dashboard JSON using either one of these workarounds:

1. Projecting the date field name in a SAQL query like this: q = foreach q generate 'CreatedDate' as 'CreatedDate'

2. Modifying the Dashboard JSON on the ValueTable's step and manually including the field name in the compact query alongside the other fields.

Reported By (0)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.