Date drill on the new canvas dashboard isn’t working the way I expected. Do I have this setup right?
- Made a simple combo chart that show metrics over time using datetime dimension called
completed
. - Made a date drill filter, connected to the visualization
- Changed the data drill dropdown in the code editor and nothing happened
- Should the dashboard update in the code editor?
- Do I have these to elements defined properly?
- Is it a bug?
Details below:
I thought it might be related to the CombinationChart
having the transformation embedded, sot I removed it from this:
ref: ref('stack_assignment_timing', 'completed')
transformation: 'datetrunc hour'
format {
type: 'datetime'
}
to this (full dashboard here:):
Dashboard team_dashboard {
title: 'Team Dashboard'
description: ''''''
view: CanvasLayout {
label: 'View 1'
height: 800
block vz_stack_volume_rate {
position: pos(0, 120, 1200, 310)
}
block d1 {
position: pos(900, 0, 300, 80)
}
}
block vz_stack_volume_rate: VizBlock {
label: 'Stack Volume and Rate'
viz: CombinationChart {
dataset: stack_examiner_timing
x_axis: VizFieldFull {
ref: ref('stack_assignment_timing', 'completed')
format {
type: 'datetime'
}
}
y_axis {
series {
mark_type: 'area'
field {
ref: ref('stack_assignment_timing', 'stacks')
format {
type: 'number'
pattern: 'inherited'
}
}
}
}
y_axis {
settings {
alignment: 'right'
}
series {
field {
ref: ref('stack_assignment_timing', 'stacks_per_hour')
format {
type: 'number'
pattern: 'inherited'
}
}
settings {
color: '#8BD2CE'
point {
value: '2023-09-01 00:00:00.000000'
color: '#8BD2CE'
}
}
}
}
settings {
show_rows_with_no_data: true
row_limit: 5000
}
}
}
block d1: DateDrillBlock {
label: 'Show by'
default: 'hour'
}
interactions: [
DateDrillInteraction {
from: 'd1'
to: [
CustomMapping {
block: 'vz_stack_volume_rate'
field: ref('stack_assignment_timing', 'completed')
}
]
}
]
}