Can users select two specific dates for comparing KPIs?

Q&A
, ,
1

Can users select two specific dates for comparing KPIs?

I have my datefield field

ifelse(
   ${Periodstarting}='Day', truncDate("DD", {hit_day_loc}),
   ifelse(${Periodstarting}='Month', truncDate("MM", {hit_day_loc}),
      ifelse(${Periodstarting}='Week', addDateTime(6, "DD", truncDate("WK", {hit_day_loc})),
         truncDate("YYYY", {hit_day_loc})
      )
   )
)

I have this CPC DoD Field. Datefield is a filter for date & time range and it just allows users to select dates in between like 2025/07/01 and 2025/08/01. Can I allow users to select two exact dates like 2025/08/05 and 2025/08/09? And it compares between those exact dates?

ifelse(
    ${Periodstarting} = 'Day',
    periodOverPeriodPercentDifference(CPC, Datefield, DAY, 1),
    NULL
)
2

Hi @Phillip_Le,

Thank you for posting

You can not select two specific dates with a single date field but you can use parameters and calculated fields to compare KPIs for the two specific date.

Kind regards,

Demola

3

Do you have an example for that? @demola

4

Hi @Phillip_Le,
You can start by building 2 datetime parameters; then depending on the value you’d like to compare, setup calculated fields to compare those values based on the date fields.
So for instance:
ifelse( ${Date1} = {Date}, sum(sales), 0)

To simplify things, you can make a field that sums each date’s value, then make another calculated field to handle the comparison aggregation you’d like to run between the two date’s values.

Let us know if you have any additional questions.

5

Hi @Phillip_Le

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

6

Hi @Phillip_Le

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!