Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Diffrenet tables one Date filter

Hello ,   1. I have a dashboard with two tables ( diffrenet ones with a date filed , EACH DATE FILED NAME IS DIFFRENET) I want to create a filter (Slicer )  that will apply on both tables , for n...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak  

    I dont have a date and time colum in my tables , and I prefer not to add columns to my tables(Since I already have a dateeith time column in them)

     

    So instead I used the similare option you guys gave earlier in the thread

    Just instead of using Calander() I created a table as follow(using kusto get data):

     

    let _stepSize = 1m;
    let _offset = 1d;
    let _startTime = startofmonth(now(), -1) - _offset;
    let _endTime = bin(now(), 1m) - _offset;
    range Timestamp from _startTime to _endTime step _stepSize
    | extend Timestamp = Timestamp + _offset
    | extend WeekOffset = toint((startofweek(Timestamp) - startofweek(now())) / 7d)
    | extend Timestamp = Timestamp - _offset
    | order by Timestamp desc
     
     
    and then I added the realations to them and it worked.
    Thanks for helping ,
Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak  

I dont have a date and time colum in my tables , and I prefer not to add columns to my tables(Since I already have a dateeith time column in them)

 

So instead I used the similare option you guys gave earlier in the thread

Just instead of using Calander() I created a table as follow(using kusto get data):

 

let _stepSize = 1m;
let _offset = 1d;
let _startTime = startofmonth(now(), -1) - _offset;
let _endTime = bin(now(), 1m) - _offset;
range Timestamp from _startTime to _endTime step _stepSize
| extend Timestamp = Timestamp + _offset
| extend WeekOffset = toint((startofweek(Timestamp) - startofweek(now())) / 7d)
| extend Timestamp = Timestamp - _offset
| order by Timestamp desc
 
 
and then I added the realations to them and it worked.
Thanks for helping ,
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

Anonymous 

 

Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.