Forum Discussion
kadapavel
Helper II
8 years agoOverlaying 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!
Managed myself
1 Reply
- kadapavel
Helper II
Managed myself