Map visualisation for azure dashboards

%3CLINGO-SUB%20id%3D%22lingo-sub-2316155%22%20slang%3D%22en-US%22%3EMap%20visualisation%20for%20azure%20dashboards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316155%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20a%20map%20to%20visualize%20regions%20of%20specific%20events.%20The%20below%20Kusto%20query%20would%20give%20the%20results%20in%20a%20simple%20chart%20format.%20I%20would%20like%20to%20achieve%20this%20in%20a%20map%20visual.%20However%2C%20I%20have%20tried%20using%20a%20workbook%20to%20do%20this%20and%20could%20get%20the%20map%20visualised%20for%20a%20constant%20time%20range%20set%20in%20the%20query.%20If%20I%20want%20to%20configure%20the%20time%20range%20in%20the%20dashboard%20itself%2C%20this%20seems%20to%20be%20impossible.%20Any%20clues%20on%20how%20I%20can%20do%20this%20would%20really%20helpful%20for%20me.%20Thanks%20in%20advance!%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Elet%20events%20%3D%20dynamic(%5B%22package%22%5D)%3B%0Alet%20mainTable%20%3D%20union%20pageViews%2C%20customEvents%2C%20requests%0A%20%20%20%20%7C%20where%20isempty(operation_SyntheticSource)%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%20'*'%20in%20(events)%20or%20name%20in%20(events)%0A%3B%0Alet%20queryTable%20%3D%20mainTable%3B%0Alet%20cohortedTable%20%3D%20queryTable%0A%20%20%20%20%7C%20extend%20dimension%20%3D%20tostring(client_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%22Country%20or%20region%22%5D%20%3D%20dimension%2C%20Counts%20%3D%20dcount_hll(merged)%3B%0AcohortedTable%3C%2FUNDEFINED%3E%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am trying to add a map to visualize regions of specific events. The below Kusto query would give the results in a simple chart format. I would like to achieve this in a map visual. However, I have tried using a workbook to do this and could get the map visualised for a constant time range set in the query. If I want to configure the time range in the dashboard itself, this seems to be impossible. Any clues on how I can do this would really helpful for me. Thanks in advance! 

 

let events = dynamic(["package"]);
let mainTable = union pageViews, customEvents, requests
    | where isempty(operation_SyntheticSource)
    | extend name =replace("\n", "", name)
    | where '*' in (events) or name in (events)
;
let queryTable = mainTable;
let cohortedTable = queryTable
    | extend dimension = tostring(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

 

0 Replies