Date Rollup to include Rollup by DATE (charts & tables)
Ideally what we would like to be able to do, and I can't imagine that we are the only ones, is to be able to just select an Any Date (Mon-Sun) Date Rollup instead of just Weekdays (M-F) (SNip.png). Additionally, when our filter is set up to show more than the last 7 days, it would do us no good to have the data from the similar DAYS summed. For example, if it were filtered to show time-stamps within the past 14 days, we would not want to just show 7 days on the X Axis (Monday-Sundayx1) as it is currently set up in the Weekday Date rollup where the counts for both Counts for Monday 3/28/16 and Monday 3/21/16 would be displayed in the same X Value=Monday. Ideally it would show 14 days on the X Axis (Monday-Sundayx2) and each DATE would have its own X Value. Really the DAY of the week is not important, only the DATE is.
I think conceptually, my description is much more complicated than it needs to be. Essentially I just want to be able to Count the number of records time-stamped per day and have it not be inherently hindered by automatically limiting the options to just show weekdays or otherwise showing every single unique time-stamp for everyday. Honestly there is no way for us to accurately display our information with the current functionality. We either would lose data for 2/7 days or just always have a straight line of values in every chart as the Y axis would never increase beyond Y=1 (pastedimage.png).
I think the easiest way to accomplish this would just be another option in the Rollup option drop down menus but am open to any other ways to accomplish this.
DATE and other new options in Date Rollup are now available in Caspio Bridge 12.0. Thank you again for your idea