Jump to content
EndzoneHero

Ad-hoc reports: trouble with grouping

Recommended Posts

Hi all,

We've just moved to Pulseway so I've tasked a junior with filling out all the Warranty info.
To that end I added a custom field: "Warranty Date: Explanation if none" for machines where there was no warranty info - e.g. a virtual machine or where the service tag was simply not recognised by the vendor website.

I then created an ad-hoc report to track his progress. I've used quite a few report builders and think I've got my head round this one but something has me really stumped: either I'm missing a bug in my grouping formula OR the grouping is screwed.

Before you ask - "Why are you using nested ifs for the grouping?", I would like to say that I did use a switch, saw the effect I am about to describe, then tried a nested if and can see the same thing

The grouping statement should only have 3 outcomes: "Got info", "Not needed" and "No info".
The right hand columns are my workings to try and see why I see the problem.
The problem is shown below the report screen grab below

image.thumb.png.086cd12b4609a5cecca1b3dbb91c3198.png

The "No info" group appears twice:

image.png.47b7fcad17815cb52e5bedff2406e08b.png

Both in the pie chart and in the table below (which i can't repeat because it contains client info).
To add insult to injury the numbers in the two "No info" groups change randomly.

I ran this 30 seconds later:

image.png.69cd34cc960a47aa699aef7ae98dc02b.png

 

If someone could please help it would be much appreciated.

I had great confidence in the product and was very excited to see such a nice report builder, but am concerned to hit a roadblock so quickly.

Thanks

EndzoneHero

 

 

 

Share this post


Link to post
Share on other sites

Hi,

I can't see all the info for the report, so it is hard to tell.  Can I suggest you check your sort and filter settings.

I had some of the same issues in graphs, what you are graphing, make sure you have as your primary sort. By the last image, I am guessing you are sorting by "Client" first so you might be seeing how many "No info" you have per client in your graph.???

Hope that helps.

Share this post


Link to post
Share on other sites

Thanks for the ideas Gary.

  • This isn't by client, it's to monitor the junior entering the warranty info to see how he's doing.
  • I show filters and sorts below, they seem ok
  • I have attached the wr file if you had time to try it on your assets. Hey - maybe we could even share reports to help each other!!

Cheers

EndzoneHero

No filters:

 

image.thumb.png.0106276f4dd6beab7a088082ed82243f.png

 

Only sorts are the one to do the grouping, and a further one to order by warranty expiration date (removing it actually makes the problem worse!)

image.thumb.png.cf5eaae223dd37868084fd4d0ee25ed2.png

INTERNAL_Warranty_information.wr

Share this post


Link to post
Share on other sites

EndzoneHero,

Sorry, just got back to the Forums here now, did not see your .wr file till now.  I will try it later and let you know what I think.

Gary

Share this post


Link to post
Share on other sites

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

×