Dashboards & Visualizations

Time/count mapping in visualization chart different from statistics/table below

sajithpv
New Member

I indexed data from a csv file and then tried to plot data for count of events every 2 minutes. I get correct results in the statistics table, but when I see the chart in visualization, the count of events get reflected for time that is > 7 hrs from what is in the table below or statistics table. Any idea why data in statistics table not match with the visualization chart? Thanks.
alt text

Tags (1)
0 Karma
1 Solution

poete
Builder

Hello @sajithpv,
This can happen in case you have a timezone settings related to your role.
I would bet the the events contain a given timezone and that your role is associated with a different one (+7 hours). Can you please check?

View solution in original post

0 Karma

poete
Builder

Hello @sajithpv,
This can happen in case you have a timezone settings related to your role.
I would bet the the events contain a given timezone and that your role is associated with a different one (+7 hours). Can you please check?

0 Karma

sajithpv
New Member

Hi @poete, under my username->preferences, timezone was set to default. After changing this to my timezone and indexing data again, this issue got resolved. Thank you very much! Though the issue is resolved, am not still clear why data representation in the chart and table below were different, if both showed a different timestamp than what was there in the data indexed, I could understand.

0 Karma

poete
Builder

@sajithpv,

I turned the comment to an answer. Please accept it in order for other to find the answer more easily.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...