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
Highlighted
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
Highlighted
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

Highlighted
Moderator

Re: Buckets on X-Axis Not Working

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

Highlighted
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
Coming Soon: Weekly Virtual User Meet-ups to answer all your questions! Stay tuned for more details to come this week.