Issue in importing Data From XL Sheet containing date and memory(Decimal) value and displaying in line chart
Hi, I have requirement of importing data from XL sheet which contains two column 1st :-Date and 2nd :-Memory. I want to display date and memory on line chart . Data on subsequent DateTime will come from XL Sheet and I want to append Date and memory to line chart. User should be able to see line graph of particular month or week after selecting range. 1st issue :- when I am converting date with parseDateTime($Date,'MM/dd/yyyy HH:mm:ss') it is changing date 15/04/2020 20:12:46 to 3/4/2021, 8:12 PM. 2nd issue :- How to display Date and memory value so that user could see memory values of particular dates/ hour. whether I should stick to line chart or go for any other widget ? Thanks in Advance.
For you first issue, you could import the data as a string and then format then in a after import process to the data you want to use. Also, if you use the Excel Importer from the App Store, you can run a microflow for the related column where you can add a specific handling of your attribute.
For your second issue, it depends on your personal favorite for the UI. But what you can do is, that you build a helper object structure where you build the objects for the line chart as you need them and then aggreagte them and provide them to the line chart in a Data Source Microflow.
I am able to display correctly processor Time Series. But Memory Time series are showing values even for empty dates.