Forum Discussion

Henrik Olofsson's avatar
Henrik Olofsson
Copper Contributor
Nov 17, 2017

Render two differenet timebuckets

Is there a convenient way to render two different timebuckets in the same chart?

 

...

| summarize avg(something) by bin(timegenerated size a, size b)?

 

Regards,

Henrik

azure monitor
Query Language
  • Meir_Mendelovich's avatar
    Meir_Mendelovich
    Icon for Microsoft rankMicrosoft
    Nov 18, 2017

    Hi,

     

    You need to summarize them separately and union them to have a single chart:

     

    union (
    Heartbeat
    | where TimeGenerated > ago(30d)
    | summarize Col1=count() by bin(TimeGenerated, 3d)
    ),
    (
    Heartbeat
    | where TimeGenerated > ago(30d)
    | summarize Col2=count() by bin(TimeGenerated, 2d)
    )
    | render timechart
     
    Thanks,
    Meir :->
     

Resources