Forum Discussion

Dalton948's avatar
Dalton948
Frequent Visitor
3 years ago
Solved

First and Last Date Metric Help

Currently trying to delevope a metric to calculate the difference between the first and last date of a specific group of data with the same "element_id" below is what i've been working on, any tips?...
General Comment
Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    Is this what you are looking for?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You have not mentioned the problem that you are facing.  Anyways, drag element_id to the visual and write this measure

Measure = max(sys_journal_field[sys_created_on])-min(sys_journal_field[sys_created_on])