I'm building an app that visualises some data from a business process. Part of that visualisation is aggregating the data in to a chart and showing a/b/c/d for the past 6 days, as well as a date selected from a drop down.
This all works perfectly when I'm in edit mode or running the app but when published, and users come to see this, they firstly can't select a date from the drop down (doesn't show any options) and the data is all aggregated in to the table where a date must be selected.
This is what I see:
And the user sees this:
Formula for the dropdown:
GroupBy(
AddColumns(
JML_error_loggings,
"dateOfLog",
Text(
Timestamp,
"[$-en-GB]dd/mm/yyyy"
)
),
"dateOfLog",
"GroupData"
)
and top table:
CountRows(
Filter(
JML_error_loggings,
DateValue(Timestamp) = DateValue(ReportingDropdown_1.Selected.dateOfLog),
'Change reason' = "Joiner"
)
)
and one of the cells from the bottom table:
CountRows(
Filter(
JML_error_loggings,
DateValue(Text(Timestamp, "[$-en-GB]dd/mm/yyyy")) = DateValue(Today()-1),
'Change reason' = "Joiner"
)
)
I appreciate there are some delegation, and probably performance issues in the formula but I'm only at a few hundred rows of data thus far and priority is getting the functionality correct.
