Public demo. Rearrange, save and share layouts as you like — the data is reset every hour. About Warp Pivot Docs Support filamentphp.com Buy a license

Busiest hours

Orders by weekday and hour of day as a heatmap. Filter by channel to compare: shops peak at lunch and after work, online orders late in the evening, and wholesale only on weekday mornings.

{"label":"Busiest hours","title":null,"expandable":true,"height":null,"expanded":{"rows":null,"columns":null},"configurable":true,"layout":{"rows":["sold_at:day_of_week"],"columns":["sold_at:hour_of_day"],"filters":[],"values":[{"name":"count","showAs":"value"}]},"fields":{"dimensions":[{"name":"sold_at:day_of_week","label":"Weekday","limit":null,"date":true},{"name":"sold_at:hour_of_day","label":"Hour","limit":null,"date":true},{"name":"channel","label":"Channel","limit":null,"date":false},{"name":"sold_at:month_of_year","label":"Month of year","limit":null,"date":true}],"measures":[{"name":"count","label":"Orders","function":"count","aggregations":[]},{"name":"amount_sum","label":"Sales","function":"sum","aggregations":["sum","avg","min","max","count","stddev","variance","median","product"]}]},"conditions":{"label":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"contains","label":"contains"},{"value":"not_contains","label":"does not contain"},{"value":"begins","label":"begins with"},{"value":"not_begins","label":"does not begin with"},{"value":"ends","label":"ends with"},{"value":"not_ends","label":"does not end with"},{"value":"greater","label":"is greater than"},{"value":"greater_equal","label":"is greater than or equal to"},{"value":"less","label":"is less than"},{"value":"less_equal","label":"is less than or equal to"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"}],"value":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"greater","label":"is greater than"},{"value":"greater_equal","label":"is greater than or equal to"},{"value":"less","label":"is less than"},{"value":"less_equal","label":"is less than or equal to"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"}],"date":[{"value":"equal","label":"equals"},{"value":"not_equal","label":"does not equal"},{"value":"before","label":"is before"},{"value":"before_equal","label":"is on or before"},{"value":"after","label":"is after"},{"value":"after_equal","label":"is on or after"},{"value":"between","label":"is between"},{"value":"not_between","label":"is not between"},{"value":"last","label":"in the last"},{"value":"current","label":"in this"},{"value":"next","label":"in the next"}],"periods":[{"value":"day","label":"day"},{"value":"week","label":"week"},{"value":"month","label":"month"},{"value":"quarter","label":"quarter"},{"value":"year","label":"year"}]},"showAs":[{"value":"value","label":"Value"},{"value":"percent_of_row_total","label":"% of row total"},{"value":"percent_of_column_total","label":"% of column total"},{"value":"percent_of_grand_total","label":"% of grand total"},{"value":"percent_of_parent_row","label":"% of parent row"},{"value":"percent_of_parent_column","label":"% of parent column"},{"value":"difference_from_previous","label":"Difference from previous"},{"value":"percent_difference_from_previous","label":"% difference from previous"},{"value":"running_total","label":"Running total"},{"value":"index","label":"Index"},{"value":"rank","label":"Rank"}],"aggregations":[{"value":"sum","label":"Sum"},{"value":"avg","label":"Average"},{"value":"min","label":"Minimum"},{"value":"max","label":"Maximum"},{"value":"count","label":"Count"},{"value":"count_distinct","label":"Distinct count"},{"value":"stddev","label":"Standard deviation"},{"value":"variance","label":"Variance"},{"value":"median","label":"Median"},{"value":"product","label":"Product"}],"calculatedValues":true,"recordFormulaColumns":[],"charts":true,"chartTypes":[{"value":"column","label":"Column"},{"value":"stacked_column","label":"Stacked column"},{"value":"bar","label":"Bar"},{"value":"stacked_bar","label":"Stacked bar"},{"value":"line","label":"Line"},{"value":"area","label":"Area"},{"value":"column_line","label":"Column and line"},{"value":"pie","label":"Pie"},{"value":"donut","label":"Donut"},{"value":"scatter","label":"Scatter"}],"forms":[{"value":"compact","label":"Compact"},{"value":"classic","label":"Classic"},{"value":"flat","label":"Flat"}],"display":{"form":"compact","totals":{"rows":true,"columns":true},"totalsPosition":"bottom","subtotals":{"rows":true,"columns":true},"mode":"grid","chart":{"type":"column","measure":0}},"savedViews":true,"urlKey":"pivot","drillDown":true,"key":"App\\Filament\\Pages\\WeekdayHeatmap","model":"10e2d0533b5b8e5d","cellActions":[],"cellClickAction":null,"exportFormats":["xlsx","csv","pdf","png"],"exportFileName":"busiest-hours","exportHeader":null,"exportFooter":null,"initialState":null,"labels":{"total":"Total","subtotal":":label Total","empty":"No data to show","loading":"Aggregating…","summary":{"count":"Count :count","sum":"Sum :sum","average":"Average :average"},"expanded":"expanded","collapsed":"collapsed","other":"Other","chartTooMany":"Showing the first :shown of :total.","chartEmpty":"Nothing to chart","menu":{"expand_level":"Expand every :label","collapse_level":"Collapse every :label","filter":"Filter :label…","sort_asc":"Sort :label A to Z","sort_desc":"Sort :label Z to A","sort_rows_desc":"Sort rows largest first","sort_rows_asc":"Sort rows smallest first","sort_rows_off":"Original order","drill_down":"Show the records","copy":"Copy","value_settings":"Value settings…","auto_width":"Fit the column to its contents"},"selected":":count of :total selected","calculated":"Calculated value","layoutInvalid":"This file is not a layout saved from a pivot."}}

Too many cells to show at once. Some headers are left out; the totals still include them. Open fewer headers or limit a dimension.

Filters

Rows

Columns

Values

Fields

No records

Actions
Open