Azure dashboard is not getting updated with new time range when pinned from workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-2330783%22%20slang%3D%22en-US%22%3EAzure%20dashboard%20is%20not%20getting%20updated%20with%20new%20time%20range%20when%20pinned%20from%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330783%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20want%20to%20visualize%20some%20data%20on%20a%20map%20and%20thereby%20I%20used%20a%20workbook.%20I%20have%20not%20set%20the%20time%20range%20in%20the%20query%20since%20the%20time%20range%20should%20be%20configurable%20in%20the%20dashboard.%20After%20pinning%20the%20particular%20tile%20to%20the%20dashboard%2C%20the%20map%20would%20not%20get%20updated%20when%20the%20time%20range%20is%20changed.%20When%20I%20change%20the%20time%20range%20in%20the%20workbook%20it%20worked%20as%20expected%20though.%3C%2FP%3E%3CP%3EPlease%20find%20the%20Kusto%20query%20that%20I%20tried%20in%20the%20workbook%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Elet%20mainTable%20%3D%20union%20customEvents%0A%20%20%20%20%7C%20extend%20name%20%3Dreplace(%22%5Cn%22%2C%20%22%22%2C%20name)%0A%20%20%20%20%7C%20where%20iif('*'%20in%20(%22*%22)%2C%201%20%3D%3D%201%2C%20name%20in%20(%22*%22))%0A%20%20%20%20%7C%20where%20true%3B%0Alet%20queryTable%20%3D%20mainTable%3B%0Alet%20cohortedTable%20%3D%20queryTable%0A%20%20%20%20%7C%20extend%20dimension%20%3D%20client_CountryOrRegion%0A%20%20%20%20%7C%20extend%20dimension%20%3D%20iif(isempty(dimension)%2C%20%22%3CUNDEFINED%3E%22%2C%20dimension)%0A%20%20%20%20%7C%20summarize%20hll%20%3D%20hll(itemId)%20by%20tostring(dimension)%0A%20%20%20%20%7C%20extend%20Events%20%3D%20dcount_hll(hll)%0A%20%20%20%20%7C%20order%20by%20Events%20desc%0A%20%20%20%20%7C%20serialize%20rank%20%3D%20row_number()%0A%20%20%20%20%7C%20extend%20dimension%20%3D%20iff(rank%20%26gt%3B%205%2C%20'Other'%2C%20dimension)%0A%20%20%20%20%7C%20summarize%20merged%20%3D%20hll_merge(hll)%20by%20tostring(dimension)%0A%20%20%20%20%7C%20project%20%5B'Country%20or%20region'%5D%20%3D%20dimension%2C%20Counts%20%3D%20dcount_hll(merged)%3B%0AcohortedTable%3C%2FUNDEFINED%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYour%20input%20on%20this%20would%20be%20highly%20helpful%20for%20me.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMonitoring%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi all,

I want to visualize some data on a map and thereby I used a workbook. I have not set the time range in the query since the time range should be configurable in the dashboard. After pinning the particular tile to the dashboard, the map would not get updated when the time range is changed. When I change the time range in the workbook it worked as expected though.

Please find the Kusto query that I tried in the workbook:

let mainTable = union customEvents
    | extend name =replace("\n", "", name)
    | where iif('*' in ("*"), 1 == 1, name in ("*"))
    | where true;
let queryTable = mainTable;
let cohortedTable = queryTable
    | extend dimension = client_CountryOrRegion
    | extend dimension = iif(isempty(dimension), "<undefined>", dimension)
    | summarize hll = hll(itemId) by tostring(dimension)
    | extend Events = dcount_hll(hll)
    | order by Events desc
    | serialize rank = row_number()
    | extend dimension = iff(rank > 5, 'Other', dimension)
    | summarize merged = hll_merge(hll) by tostring(dimension)
    | project ['Country or region'] = dimension, Counts = dcount_hll(merged);
cohortedTable

Your input on this would be highly helpful for me. Thank you!

0 Replies