Forum Discussion

iamdmitry's avatar
iamdmitry
Frequent Visitor
7 years ago
Solved

How calculate quantity difference (distinct count) between row date and selected date

Hello, guys!   Please, help me or give me some advice, how calculate quantity difference (distinct count) between row date and selected date.   For example, if selected date is 31-1-18:   Date ...
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Try:

     

    fixed quantity = calculate(distinctcount(ID), filter(ALL(table), Date = Date(2018, 1, 31)))
dynamic quantity = distinctcount(ID)
diff = dynamic quantity - fixed quantity
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Try:

 

fixed quantity = calculate(distinctcount(ID), filter(ALL(table), Date = Date(2018, 1, 31)))
dynamic quantity = distinctcount(ID)
diff = dynamic quantity - fixed quantity