Create a Histogram with More Buckets

Reply
Highlighted
Visitor

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
Visitor

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. 


All Replies
Visitor

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. 

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!