Forum Discussion
Solved
Keep first value
Hello, I have a simple excel sheets with names and dates when they logged in an application. I need to keep (count) only their first log-in, delete the rest (or keep, but just count the first lo...
In Query Editor, try the Group By Feature -> Advanced to Select the MIN Login (by Email) and COUNT of Rows.
After that, you can take the GROUPED DATA into a simple chart.
KatkaS , not very clear. Do we need to calculate first log in (Logic)
calculate(countrows(table),filter(table, table[Result] in{"delete","First log in"}))