topic Time Variable - Using a dimension as variable in App Development

Time Variable - Using a dimension as variable

Nolan — Fri, 23 Sep 2022 16:32:48 GMT

Hello,

We currently have a situation where we are attempting to insert this date field variable in the set expression below:

Sum({1 <Month= {$(vProductTime)}>} [QTY Each])

where vProductTime = [Product Date]

ProductDate being the date a product started on a specific contract. Date formatting between 'Month' & 'vProductTime' and all else equal, this expression only returns us 0 values. The expression looks correct to us, but is there anything in the syntax we are missing or is there some other easy fix?

Appreciate any help you can offer

Re: Time Variable - Using a dimension as variable

RafaelBarrios — Fri, 23 Sep 2022 20:43:25 GMT

Hi @Nolan

can you share screenshots of:

1. how the variable vProductTime is created

2. what is in this field Month

my first guess is that you are comparing a month name or number with a complete date.

and that you are missing a = sign en variable formula.

best,

Re: Time Variable - Using a dimension as variable

Nolan — Tue, 27 Sep 2022 15:49:52 GMT

Hi Rafael,

Thanks for the reply.

The actual dimension and variable names are slightly different, but the same logic follows. The Variable is defined as the dimension below:

And our Month dimension is defined as this, which I have tried to match the formatting in the Product Month dimension

Basically we are trying to display data from the start of implementation of the contract and onward. So when you filter on a certain product, that specific implementation date is applied and displays only the relevant data.

Thanks for any insights you are able to provide.