Forum Discussion

khartleymb's avatar
khartleymb
Regular Visitor
2 years ago
Solved

Two time series tables from same sensors same plot

Hi all,  I'm working on a problem where I have two tables of hydrologic sensor data and need them on the same plot.  One table is a one month of real time data measured every 5 minutes. The Fields ...
Need Help
  • khartleymb's avatar
    khartleymb
    2 years ago

    I figured it out!

    I needed a third main "table" that would allow me to relate to both datasets (so "fact" table, then two tables of the sensors, historical and real time sensor info) 
    The other thing I needed to make a "DATE" table of only date to relate to both the historical and fact table to normalize date between the two tables. To get a date table I used a measure of DAX - with (

    datetbl = CALENDARAUTO()) 

    With everything related I could plot the historical (max and min for each day)  and real time datasets by station ID - also can link to a map and water basin! 

khartleymb's avatar
khartleymb
Regular Visitor
2 years ago

I figured it out!

I needed a third main "table" that would allow me to relate to both datasets (so "fact" table, then two tables of the sensors, historical and real time sensor info) 
The other thing I needed to make a "DATE" table of only date to relate to both the historical and fact table to normalize date between the two tables. To get a date table I used a measure of DAX - with (

datetbl = CALENDARAUTO()) 

With everything related I could plot the historical (max and min for each day)  and real time datasets by station ID - also can link to a map and water basin!