Forum Discussion

82186's avatar
82186
Frequent Visitor
2 years ago

Subtract one time from another

The database has a counter for recording the time of signals (Date of recording) There is a machine and this machine sends a signal from the beginning of the cut (LD_11_Cnt_Saw1_Cut Start) and its co...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

The ID column in your sample was out of sequence.  Should it be ignored and the sorting be done based on timestamp instead?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    I don't understand how Unit number correlate with "The name"  items.

     

    Note that your datetime slicers will not work as long as they come from the same table.

     

  • 82186's avatar
    82186
    Frequent Visitor
    2 years ago

    What can you do then?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Use disconnected tables for your slicers.

  • 82186's avatar
    82186
    Frequent Visitor
    2 years ago

    Can you please send an example?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    example of what?

     

    Duplicate your table, or create separate tables for the time ranges. 

     

    What is your business users' expectation?  Have they expressed how they would like to pick the date ranges?  Are they concerned about the amount of screen space taken up by your slicers?