Jump to content

Histogram issues with "Day of Week" aggregation


Recommended Posts

Hi,

I have a strange issue when aggregating data in a histogram. I am counting the number of samples for a signal and aggregate by first using "Year" and the using "Day of the Week" as the aggregation type:

image.png.e518338f18fd62537a2951228a075fbb.png

This gives me the following histogram with a count of 246 samples for monday in 2012:

image.png.8cb15263904020ff0aa70dfb756c7ffa.png

But these data should belong to sunday. I set up another histogram using the following condition as the second aggregation type:

image.png.eb4c41c41a8ddf08b7b90d5089c22f2b.png

image.png.a9df7d9d70367f9840e07c647ad8a930.png

The result now looks like this (which is correct):

image.png.7650749e4ef4c25506cab4e1c34d98a2.png

This is for the other days as well. Is there any way to get around this issue? Installed Seeq version is R21.0.40.01-v201812312325

Regards,

Thorsten

 

 

 

 

 

 

Edited by Thorsten Vogt
Link to comment
Share on other sites

  • Seeq Team

You've found a bug! It's a two-fold issue

  1. The histogram is localizing the "day of week" labels using your browser's settings (The rest of the app is in English, but I infer your browser is set to prefer German)
  2. That localization code is treating the "start of the week" differently. Much of the world starts their week on Monday, others start it on Sunday, so there's an off-by-one error in looking up the proper label.

I've filed CRAB-14766 so that we can track this.

You've identified a creative workaround that sidesteps the bug. If your analysis can be done in English (US), changing your browser settings would also resolve it. 

Thanks for the question!

Link to comment
Share on other sites

  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...