Instead of me creating standard data reports in the appsheet …I want users to filter what they want ..and generate report. Is that possible in appsheet? Can we use Power BI for this?
The main goal is users can customize what reports they want.
Yes, that is possible. Please take a look a the following sample app. In this app, based on the color selection using the enum option by the user, the chart changes. Basically the user selection is given as an input to a slice and the sliced or filtered data per selection data is used for chart input. However the sample app referred below is for a single user. For multi user operations , you will need a users’ table that has one record per user to store her/his selections.
Please note that for a secured data access ( meaning a user’s device gets only that data which the user is supposed to have access to) you will need to use security filters rather than slice based filtering technique.
However AppSheet has very limited charting capabilities and within available charts types also there are multiple limitations. This is natural because AppSheet is not primarily a data visualization tool. So for a very deep or advanced data visualization, native AppSheet charts may not be a right choice.
Yes, you can user Power BI or Data Studio within Google ecosystem.
Please note that recently Looker Studio was again renamed simply as Data Studio.
I just want to add some info regarding it:
- Charts that are mostly used in AppSheet are Bar and Donut. Besides, there are Maps and Scatter Plots, but only in specific cases.
- Data Studio (formerly Looker Studio) free plan has a limit on data refreshing frequency. It refreshes after 15 minutes as the minimum interval.
Thank you @Minhku for adding details. Yes, if update frequency is of importance in a use case, then Data Studio Pro ( a paid version) will be required. It can refresh every 5 minutes.