Apex Code Development You need to sign in to do that
Don't have an account?
Hi Einstein Analytics Expert, Month and Quarter filter binding with Bar Chart in Einstein Analytics
I have two filter, One for Month and one for Quarter, and I want to bind these two filter dynamic for my bar chart.
Month Filter is-
"query": "q = load \"AARP_DATA_24OCT\";\nq = group q by 'DATAMONTH_Month';\nq = foreach q generate 'DATAMONTH_Month' as 'DATAMONTH_Month', count() as 'count';\nq = order q by 'DATAMONTH_Month' asc;\nq = limit q 2000;",
Quarter Filter is-
"query": { "measures": [ [ "count", "*" ] ], "groups": [ "DATAMONTH_Quarter" ] },
And my Chart with which have to bind is
"query": "\nq = load \"AARP_DATA_24OCT\";\nq = filter q by 'BRIOVA_NONBRIOVA_DISP' == \"1\";\nq = group q by 'Therapy';\nq = foreach q generate 'Therapy' as 'Therapy', sum('GROSS_INCOME')/1000000 as 'Briova';\nr = load \"AARP_DATA_24OCT\";\nr = group r by 'Therapy';\nr = foreach r generate 'Therapy' as 'Therapy', sum('GROSS_INCOME')/1000000 as 'Total';\ns = union q ,r;\ns = group s by 'Therapy';\ns = foreach s generate 'Therapy' as 'Therapy', sum('Total') as 'Total', sum('Total')-sum('Briova') as 'Leakage', sum('Briova') as 'Pull Through';\ns = filter s by 'Leakage' > 0;\ns = order s by 'Total' desc;",
How to Bind these two fields in my bar chart?
Month Filter is-
"query": "q = load \"AARP_DATA_24OCT\";\nq = group q by 'DATAMONTH_Month';\nq = foreach q generate 'DATAMONTH_Month' as 'DATAMONTH_Month', count() as 'count';\nq = order q by 'DATAMONTH_Month' asc;\nq = limit q 2000;",
Quarter Filter is-
"query": { "measures": [ [ "count", "*" ] ], "groups": [ "DATAMONTH_Quarter" ] },
And my Chart with which have to bind is
"query": "\nq = load \"AARP_DATA_24OCT\";\nq = filter q by 'BRIOVA_NONBRIOVA_DISP' == \"1\";\nq = group q by 'Therapy';\nq = foreach q generate 'Therapy' as 'Therapy', sum('GROSS_INCOME')/1000000 as 'Briova';\nr = load \"AARP_DATA_24OCT\";\nr = group r by 'Therapy';\nr = foreach r generate 'Therapy' as 'Therapy', sum('GROSS_INCOME')/1000000 as 'Total';\ns = union q ,r;\ns = group s by 'Therapy';\ns = foreach s generate 'Therapy' as 'Therapy', sum('Total') as 'Total', sum('Total')-sum('Briova') as 'Leakage', sum('Briova') as 'Pull Through';\ns = filter s by 'Leakage' > 0;\ns = order s by 'Total' desc;",
How to Bind these two fields in my bar chart?