When using the Timestampdiff result is attribute- How to turn into metric?
SummaryThe result of a calculation in DV with TImestampdiff the result is an Attribute. Can't be swiched to Measure.
When creating a calculation to calculate e.g. the current age of a person by using:
TIMESTAMPDIFF(SQL_TSI_YEAR, XSA('weblogic'.'Workforce Management - Worker Assignment Real Time')."Columns"."Person Date of Birth", CURRENT_DATE)
the result is marked as Attribute. When using the 'treat as' the symbol to the calculation is not changing from A to #. The problem then is when you want to drag the calculated item into the '# Values' section of a visualization it is not allowed.