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