topic Re: Increment Count Totals over a Line Chart in Dashboards & Visualizations

Increment Count Totals over a Line Chart

jzwulf — Mon, 19 Jul 2021 13:14:37 GMT

I have a set of data that has a data field inside that shows when an asset has been assigned. Right now, we're pulling the total count of those assets, but have been asked to show an incrementing count over the course of a line chart.

The data looks something like this:

Asset ID	Assigned Date
123	7/12/21
124	7/12/21
125	7/13/21
126	7/14/21

I want the data in the chart to show like this:

7/12/21: 2
7/13/21: 3
7/13/21: 4

Essentially, after each date from the start, the chart adds the previous dates, and charts the total.

Thanks in advance.

Re: Increment Count Totals over a Line Chart

kamlesh_vaghela — Mon, 19 Jul 2021 13:30:58 GMT

@jzwulf

Can you please try this?

YOUR_SEARCH | streamstats count | eventstats max(count) as m by Assigned_Date | where count=m | table Assigned_Date count

My Sample Search :

Thanks
KV
▄︻̷̿┻̿═━一 ?

If any of my reply helps you to solve the problem Or gain knowledge, an upvote would be appreciated.

Re: Increment Count Totals over a Line Chart

ITWhisperer — Mon, 19 Jul 2021 13:37:33 GMT

| streamstats dc(AssetID) by AssignedDate

Re: Increment Count Totals over a Line Chart

jzwulf — Mon, 19 Jul 2021 16:52:33 GMT

Changed it a bit to fit our actual fields, but this got us there! Thanks a bunch!