Duplicate

Duplicate calculations support date dimensions and non-date dimensions. There are two types of calculation methods for duplicate calculations:

• By Condition
• By Count

There are two types of calculation results for duplicate calculations:

• Duplicate Count
• Duplicate Rate

Duplicate calculations support specifying time fields and time filtering conditions to calculate the number of repetitions/repetition rates for specific times.

By Condition

The number of measures that meet the repetition condition will be counted for all measures under the dimension.

By Count

The count will tally the number of repetitions of the measure under this dimension. If a measure appears only once, the repetition count is 0; if it appears twice, the repetition count is 2.

Example of Duplicate Count

Example of Repetition Rate

Time Filter

Calculate the number of repetitions/repetition rate at a specific time.