Forum Discussion

ok_kpop's avatar
ok_kpop
Frequent Visitor
3 years ago
Solved

Create a Table for Duplicate Values within Same Day

I want to create a table where it'll show if there are duplicate time intervals within one day. For example, in the current spreadsheet I have loaded into the file attached below, there's (2) 800am intervals in Day 1. 

 

I want the table to list the day and all the time intervals that are repeated (if there are any). If there's no duplicate time intervals within a day, I want it to just say "No duplicates" :

 

 

 

DUMMY FILE 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    ok_kpop , Create a measure like

     

    Measure =

    var _1 = countrows(Table)

    return 

    if(_1 >1, "duplicates", "No duplicates")

     

    Plot this with day in a visual

2 Replies