Visual Overview DateTime -x Hour

71 viewsdatetime parameter Visual Overview
1
0 Comments

Hi All

I'm just wondering if anyone knows if its possible to display a date/Time from a parameter on a visual overview but have it display -1 hour instead of the retrieved datetime from the parameter?

Thanks

Ryan

Toon Casteele [SLC] [DevOps Enabler] Answered question 2 days ago

1 Answer

1
7.26K 3 Comments

In a Visual Overview you can perform simple date-time calculations inside a dynamic placeholder.
The “[Subtract: … ]” placeholder allows you to show the value of a datetime parameter minus a specific TimeSpan.

Example (you can put this in shape text or most shape data fields)

[Subtract:[param:MyElement,123],01:00:00]

• 123 = the ID of the datetime parameter
• 01:00:00 = one hour (HH:MM:SS)

At run-time the placeholder returns the parameter value shifted one hour back, so the shape will display “parameter time – 1 h”.

Source: https://docs.dataminer.services/dataminer/Operator_guide/Visio/reference/Placeholders_for_variables_in_shape_data_values.html#subtract

Toon Casteele [SLC] [DevOps Enabler] Posted new comment 16 hours ago
Ryan Hepworth [DevOps Advocate] commented

Thanks Toon, I will take a look, I must have missed that bit in the documentation when I was looking for it
Ryan Hepworth [DevOps Advocate] commented

Hi Toon, can this be used in the Parameter shape data field?

My parameter is a table parameter so I need to extract it based on Display Key
Toon Casteele [SLC] [DevOps Enabler] commented

With param placeholders, you should also be able to pass along the key to get the right value as well. If that doesn't work you can also use the SubscriptionFilter shape data alongside to ensure it does.