Forum Discussion
Measure that shows Simultaneous Entries by Time
This table logs individuals that have logged into the network using the Date & Time columns. Please help me to write a measure that shows, “how many simultaneous logs happened at any given time?”
| First Name | Last Name | Opt Out From Emails? | Date | Time | |
| namef1 | namel1 | [email protected] | TRUE | Thursday, April 11, 2024 | 9:59:00 AM |
| namef2 | namel2 | [email protected] | TRUE | Thursday, April 11, 2024 | 9:59:00 AM |
| namef3 | namel3 | [email protected] | TRUE | Thursday, April 11, 2024 | 9:59:00 AM |
| namef4 | namel4 | [email protected] | TRUE | Thursday, April 11, 2024 | 11:00:00 AM |
| namef5 | namel5 | [email protected] | TRUE | Thursday, April 11, 2024 | 2:59:00 AM |
| namef6 | namel6 | [email protected] | TRUE | Thursday, April 11, 2024 | 9:59:00 AM |
| namef7 | namel7 | [email protected] | TRUE | Thursday, April 11, 2024 | 9:59:00 AM |
The answer will vary depending on the context of 'any given time'.
Something as simple asRow Count = COUNTROWS(tableName)will return the number of rows in the table and will accept any context applied by a visual.
Using your example data the above measure would returnin a table visual with the date and time columns added as context.
The same measure would returnin a card visual with no context applied.
1 Reply
jgeddesSuper User
The answer will vary depending on the context of 'any given time'.
Something as simple asRow Count = COUNTROWS(tableName)will return the number of rows in the table and will accept any context applied by a visual.
Using your example data the above measure would returnin a table visual with the date and time columns added as context.
The same measure would returnin a card visual with no context applied.