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 ,
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Does the above replies helps. if you need more help make me @

Appreciate your Kudos.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello amitchandak 

unfortuantly it didnt work , I think the problem is that my Date table i created using CALENDERAUTO()

is without time , while my other 2 tables are with time.

 

Any chance that thisis the problem , and would anyway like to know how to create a slicerwith time as well.

 

Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey amitchandak 

      I dont understand what do you mean  ,  can youplease alobrate as in what should I do . 

      for now what I did was creating the following table

      {TimeTable =

      VAR HourTable = SELECTCOLUMNS(GENERATESERIES((0), (23)), "Hour", [Value])

      VAR MinuteTable = SELECTCOLUMNS(GENERATESERIES((0), (59)), "Minute", [Value])

      VAR SecondsTable = SELECTCOLUMNS(GENERATESERIES((0), (59)), "Second", [Value])

      RETURN
       
      ADDCOLUMNS(

      CROSSJOIN(HourTable, MinuteTable, SecondsTable),

      "Time", TIME([Hour], [Minute], [Second])

      ) }
      Now I have 2 tables , one calender and the other one timtable
       so I am not sure what do you mean hen saying join it with calander , how do I join them into one field ?
      and make the relation to the other tables?
       
      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

        All you tables transaction(Fact) table will have date and time columns and they will join these date and time tables on date and time column. These Date calendar and time table will act as the master table will be used in the analysis.

         

        If possible, share pbix file after removing sensitive information.

        Like this