Narrow vs. Wide Tables - Part 2
Continuing on with the two part series about Narrow vs. Wide tables, this video will go into how to best filter your data, especially if you have a large amount. It will present the data within the structure we'd created within the first video.
Knowing the impact of data operations isn't just limited to the structure of your tables. It's also about how much data is loaded and shown to the user based on what the user needs to see. If you have a relationship resulting in hundreds of thousands of possible records, it doesn't really make sense to show anything other than what the user really needs to see.
If the user only needs to see 3 months of data then simply load the three months and allow the UI to provide options to adjust. That's exactly what we cover within this video. Let's learn how to limit what is shown within your narrow table structure.
Comments
FYI: Finding Last Day of Month
In you video you used "Date(Month+1,1, Year) -1"
A 'cleaner' (maybe not intuitive) would be "Date(Month+1,0,Year)" This is the same as Date(Month+1, 1-1, Year)
Last Day of Month
you could also use Date ( Month + 1 ; 0 ; Year ( Get ( CurrentDate) )
sort on date field does not work since there is no jsondate type
how can that be handled showing loading the data as YYYY/MM/DD and then somehow masking it as US type od date??
maybe there is a java script function??
Peter
Peter Cortiel