GitHub user tien260604 added a comment to the discussion: Passing parameters
Now I pass parameters to the charts ok but I want each chart to have its own
filter when clicking on it on the dashboard.
There is my code now:
{% if filter_values('Nam')|length > 0 %}
{% set nam_filter = filter_values('Nam')[0] %}
{% else %}
{% set nam_filter = 2025 %}
{% endif %}
WITH DuLieu AS (
SELECT *
FROM OPENQUERY([LINK_CMF],
'EXEC CMF_Dashboard.dbo.DBD_OM_DoanhThuBanHang
@MaCongTy = NULL,
@Nam = N''{{ nam_filter }}''
WITH RESULT SETS
(
(KH01 FLOAT, KH02 FLOAT, KH03 FLOAT, KH04 FLOAT, KH05 FLOAT, KH06
FLOAT,
KH07 FLOAT, KH08 FLOAT, KH09 FLOAT, KH10 FLOAT, KH11 FLOAT, KH12
FLOAT,
TT01 FLOAT, TT02 FLOAT, TT03 FLOAT, TT04 FLOAT, TT05 FLOAT, TT06
FLOAT,
TT07 FLOAT, TT08 FLOAT, TT09 FLOAT, TT10 FLOAT, TT11 FLOAT, TT12
FLOAT,
KTruoc01 FLOAT, KTruoc02 FLOAT, KTruoc03 FLOAT, KTruoc04 FLOAT,
KTruoc05 FLOAT, KTruoc06 FLOAT,
KTruoc07 FLOAT, KTruoc08 FLOAT, KTruoc09 FLOAT, KTruoc10 FLOAT,
KTruoc11 FLOAT, KTruoc12 FLOAT,
PTram01 FLOAT, PTram02 FLOAT, PTram03 FLOAT, PTram04 FLOAT,
PTram05 FLOAT, PTram06 FLOAT,
PTram07 FLOAT, PTram08 FLOAT, PTram09 FLOAT, PTram10 FLOAT,
PTram11 FLOAT, PTram12 FLOAT)
)'
)
)
SELECT 1 AS Thang, KH01 AS DT_KeHoach, TT01 AS DT_KyNay, KTruoc01 AS
DT_KyTruoc, PTram01 AS KT_TH, {{ nam_filter }} AS Nam FROM DuLieu UNION ALL
SELECT 2, KH02, TT02, KTruoc02, PTram02, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 3, KH03, TT03, KTruoc03, PTram03, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 4, KH04, TT04, KTruoc04, PTram04, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 5, KH05, TT05, KTruoc05, PTram05, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 6, KH06, TT06, KTruoc06, PTram06, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 7, KH07, TT07, KTruoc07, PTram07, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 8, KH08, TT08, KTruoc08, PTram08, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 9, KH09, TT09, KTruoc09, PTram09, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 10, KH10, TT10, KTruoc10, PTram10, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 11, KH11, TT11, KTruoc11, PTram11, {{ nam_filter }} FROM DuLieu UNION ALL
SELECT 12, KH12, TT12, KTruoc12, PTram12, {{ nam_filter }} FROM DuLieu;
GitHub link:
https://github.com/apache/superset/discussions/35462#discussioncomment-14579439
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
