Buckets on X-Axis Not Working

Reply
Highlighted
Green Belt

Buckets on X-Axis Not Working

For my X-Axis, I have:

 

(CASE 
 WHEN AVG(`MinutesToContact`) <= 5 THEN '0:00 - 5:00'
 WHEN AVG(`MinutesToContact`) > 5 AND AVG(`MinutesToContact`) <= 10 THEN '5:01 - 10:00'
 WHEN AVG(`MinutesToContact`) > 10 AND AVG(`MinutesToContact`) <= 20 THEN '10:01 - 20:00'
 WHEN AVG(`MinutesToContact`) > 20 AND AVG(`MinutesToContact`) <=30 THEN '20:01 - 30:00'
 WHEN AVG(`MinutesToContact`) > 30 THEN '30:01 +'
END)


When I try to plot:

COUNT(`LeadId`)

It tells me no data exists. The time date range is set to all time. Anyone have any ideas?


Accepted Solutions
Black Belt

Re: Buckets on X-Axis Not Working

If you add to the last line of your beastmode

 

 WHEN AVG(`MinutesToContact`) > 30 THEN '30:01 +'
ELSE 'OMITTED' END)

would it fix it ? also bring that beastmode into the filter's box and exclude 'OMITTED' from your card.

 

if it does still not work, then check what type of values your are getting for `MinutesToContact` , what is their format

 

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post


All Replies
Black Belt

Re: Buckets on X-Axis Not Working

If you add to the last line of your beastmode

 

 WHEN AVG(`MinutesToContact`) > 30 THEN '30:01 +'
ELSE 'OMITTED' END)

would it fix it ? also bring that beastmode into the filter's box and exclude 'OMITTED' from your card.

 

if it does still not work, then check what type of values your are getting for `MinutesToContact` , what is their format

 

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

View solution in original post

Moderator

Re: Buckets on X-Axis Not Working

@czmudzinski, did Godiepi's reply help you out? 

Green Belt

Re: Buckets on X-Axis Not Working

It was actually the AVG of the calculations that wasn't allowing the data to be aggregated.

 

Thanks.

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!