I collect daily checkouts. It has a date, amount collected, etc… I want to create monthly summaries. What’s the best way to do that? I was thinking of creating another UX for reports. Maybe create a slice for each month? I’m also not sure which formula to use to select only that month. Also, is it possible for me to have a summary from a different table on the same report? Basically, I have multiple tables. I want a monthly summary of each table on the same UX. I don’t need to add them together though.
Tin_Nguyen1:
Maybe create a slice for each month? I’m also not sure which formula to use to select only that month.
MONTH( [date_column] ) = MONTH( TODAY() )
Tin_Nguyen1:
Also, is it possible for me to have a summary from a different table on the same report?
What exactly do you mean by “report”? This?
You can include whatever tables you want in a Report/Workflow template. In order to add additional tables to a UX-View, you’d need to use a dashboard of multiple sub-views.
1 Like
Yes. I think I need a dash board. I want it see multiple fields on the same UX.
,
Interactive Dashboard Tips & Tricks ?
When building Dashboards, make sure you try enabling ‘Interactive’ mode - if your views are built from similar or related tables, they will dynamically change as items are selected. [Interactive%20Dashboard] Here’s another example of a calendar of events that is related to 3 other tables: Staff Members, Inspection Points & Facilities. [Interactive%20Dashboard_Calendar] Recent dashboard updates now allow end app users to customize the layout of the dashboard they’re using to best fit the sc…
1 Like