recon_gen.common.clickability

Conditional-format helpers that cue which table cells are clickable.

Two visual languages, so users can tell click idioms apart at a glance:

• link_text_format — plain accent text color. Mark cells whose click target is the visual’s own left-click (DATA_POINT_CLICK) drill.

• menu_link_text_format — accent text + pale tint background. Mark cells whose click target is a right-click (DATA_POINT_MENU) action, used when the visual already has a left-click action reserved for something else (same-sheet chart filter, another drill, etc.).

Background: QuickSight’s conditional-formatting expression grammar is undocumented. The idiomatic always-true guard (confirmed by UI round-trip) is {col} <> "<sentinel>" — compare the column to a value no row ever holds. Literal booleans, 1 = 1, and self-equality are all rejected.

Functions

link_text_format(field_id, column_name, color)	Render a drill-source cell in color to cue left-click drill-down.
menu_link_text_format(field_id, column_name, ...)	Render a drill-source cell in text_color on a bg_color tint to cue a right-click (DATA_POINT_MENU) drill — distinguishes from the plain-accent left-click style produced by link_text_format.

recon_gen.common.clickability.link_text_format(field_id, column_name, color)

Render a drill-source cell in color to cue left-click drill-down.

Return type:

dict[str, Any]

Parameters:

• field_id (str)

• column_name (str)

• color (str)

recon_gen.common.clickability.menu_link_text_format(field_id, column_name, text_color, bg_color)

Render a drill-source cell in text_color on a bg_color tint to cue a right-click (DATA_POINT_MENU) drill — distinguishes from the plain-accent left-click style produced by link_text_format.

Return type:

dict[str, Any]

Parameters:

• field_id (str)

• column_name (str)

• text_color (str)

• bg_color (str)