Create a Histogram with More Buckets

Reply
White Belt

Create a Histogram with More Buckets

Domo's histogram card currently only allows a maximum of 20 buckets which may not be enough. How do i create a histogram with 1000 buckets?


Accepted Solutions
White Belt

Re: Create a Histogram with More Buckets

One way to do this is with the Width_bucket function in a beast mode. This function allows you to create custom buckets for your histogram. 

For example,

WIDTH_BUCKET ( `mean`, 0, 60000, 4000 )

or

WIDTH_BUCKET ( `mycolumn`, histogram_min, histogram_max,  Number_of_buckets )

 

 

Try this

  1. Create a new card and choose the normal vertica bar chart
  2. Create a new Beastmode, let's call it "Bucket".
    1. WIDTH_BUCKET ( `mean`, 0, 60000, 4000 )
  3. On the Vertica bar chart
    1. X-axis
      1. =Bucket (this is the beast mode we just created)
    2. Y-axis
      1. Count of the mean
        1. This should be the count of the means
    3. Sorting
      1. =Bucket Ascending (No aggregation)

 

This should give you a nice histogram with however many buckets you need.  See attached images for more context. 

View solution in original post


All Replies
White Belt

Re: Create a Histogram with More Buckets

One way to do this is with the Width_bucket function in a beast mode. This function allows you to create custom buckets for your histogram. 

For example,

WIDTH_BUCKET ( `mean`, 0, 60000, 4000 )

or

WIDTH_BUCKET ( `mycolumn`, histogram_min, histogram_max,  Number_of_buckets )

 

 

Try this

  1. Create a new card and choose the normal vertica bar chart
  2. Create a new Beastmode, let's call it "Bucket".
    1. WIDTH_BUCKET ( `mean`, 0, 60000, 4000 )
  3. On the Vertica bar chart
    1. X-axis
      1. =Bucket (this is the beast mode we just created)
    2. Y-axis
      1. Count of the mean
        1. This should be the count of the means
    3. Sorting
      1. =Bucket Ascending (No aggregation)

 

This should give you a nice histogram with however many buckets you need.  See attached images for more context. 

View solution in original post

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