Forum Discussion

kadapavel's avatar
kadapavel
Helper II
8 years ago
Solved

Overlaying graphs using common calendar

Hello,

I'm monitoring many parameters from sensors and keep them in Azure table storage. For certain activities I need to connect  and see recording on line chart and very often need to overlay different graphs.

Big challlenge is to show different characteristics on one visual, each of graph may have different recording sample time(frequency).

 

What I read in different topics in community, that i can create common calendar and connect all recordings to that, but did not succed. Here are examples:

Data

What I tried

 

Date = 
ADDCOLUMNS (
CALENDAR (DATE(2016,1,1), DATE(2018,12,31)),
"DateAsInteger"     , FORMAT ( [Date], "YYYYMMDD" ),
"Year"              , YEAR ( [Date] ),
"Monthnumber"       , FORMAT ( [Date], "MM" ),
"YearMonthnumber"   , FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort"    , FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort"    , FORMAT ( [Date], "mmm" ),
"MonthNameLong"     , FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber"   , WEEKDAY ( [Date] ),
"DayOfWeek"         , FORMAT ( [Date], "dddd" ),
"DayOfWeekShort"    , FORMAT ( [Date], "ddd" ),
"Quarter"           , "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter"       , FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" )
)

Then I tried to link Date with TimeStamp...

Time stamp has also Hours, Minutes and Seconds, that shall be also considered...

 

Thanks in advance for all suggestions!

 

 

1 Reply