Forum Discussion
Counting hourly dependant on a serial
Hi Skinken ,
I would add a [dateOnly] column to the data in Power Query. You can do this by selecting your [Timestamp] field in Power Query, then go to the Add Column tab, then find the Date button on the ribbon and select 'Date Only'.
Apply this change to the model.
Then create a measure something like this:
_noofPings = COUNT(yourTable[Serial])Add [Serial], [dateOnly], and [_noofPings] to a table visual and this should show you what you want.
You can click on the [_noofPings] column header of the table visual to sort high-low/low-high.
Pete
Super UserHi Skinken ,
I would add a [dateOnly] column to the data in Power Query. You can do this by selecting your [Timestamp] field in Power Query, then go to the Add Column tab, then find the Date button on the ribbon and select 'Date Only'.
Apply this change to the model.
Then create a measure something like this:
_noofPings = COUNT(yourTable[Serial])
Add [Serial], [dateOnly], and [_noofPings] to a table visual and this should show you what you want.
You can click on the [_noofPings] column header of the table visual to sort high-low/low-high.
Pete
Hi pete
Thanks for your help so far 😀 the program basicly works.
Do you have an idear for what can be done if i want to summarize pings for 1 serial for the whole week ( 7 days span ?)
Im thinking you can do it by simply taking each serial and link them to the new _noofpings column and then sumarize over every occasion of the serial?
Hope i make sense 😀
- BA_Pete
Hi Skinken ,
You don't need to do anything special, just remove the [dateOnly] field from your visual.
As your dataset is only ever 7 days, doing this will just show the total count for your entire dataset. Likewise, if you also remove the [Serial] field, you will just be left with the total pings across all machines for the entire dataset.
BTW, you mentioned the [_noofPings] COLUMN above, but that calculation definitely should not be a column, it must be a MEASURE to work as required.
Pete
