How can I change in the Y-Axis the count number for values with hours in timechart

[danielgp89]

Hello Everyone!

We want to make a timechart similar to this one that we made in excel.

In Splunk I tried everything but I can't change the Y-axis values the only thing that I achieve is the next visualization

How can I put the hours of execution in the Y-axis

This is my search

index="controlm" 
|eval fecha=strftime(_time,"%Y-%m-%d")
|timechart span=1h count by job_member_name  limit=4 useother=f

[vnravikumar]

Hi @danielgp89

Please check the suggestion given by @niketnilay here

https://answers.splunk.com/answers/661288/time-on-y-axis-and-date-on-x-axis.html

[woodcock]

It is not clear what you mean.

[danielgp89]

In the Y-axis I want to represent the hours instead of how many events happen!

For example in the Y-axis: I want the hours and in the X-axis we want the date!

We want to represent in a chart like the first one at what time of day by date there were more activity with some tasks.

[woodcock]

What in the world do you mean by hours? Show me some sample events and how hours would be calculated for one timeslice.