Forum Discussion

NithinBN's avatar
NithinBN
Icon for Helper II rankHelper II
4 years ago

Perform historical analysis using main data and change log.

Hello All,   how can I do perform historical analysis based on Initial State and Change Log data.           to get a table like this.   Should I create a new table or conn...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago
Table = 
  GENERATE(
    SUMMARIZE('Table1',[Data],[ID]),
    SUMMARIZE('Table2',[State],[Priority])
  )

NithinBN Seems like you want something like: