Multiple dashboards with filtered slices in an App

Hi everyone,

I have a database with registered transactions as you can see in the table below (left side).

My App has multiple Dashboards that separate the transactions by Currency, where each Dashboard contains different slices (all of them with the same aim and behaviour, except the currency that changes depending on which Dashboard you are). You can see in the picture above (right side) a simple example where it has 2 slices and a Filter_Account (that applies the dashboard interactive mode).

My question is: Would I have to create a slice for each of the Dashboards like the right side of the figure above, i.e. 2 slices for “Dashboard_EUR” and 2 slices for “Dashboard_USD”?

Or would it be possible to create only a single Slice called “Slice_Expenses” and a single Slice called “Slice_Revenues” and implement a function that filters by Currency and it will be activated when I click on a certain Dashboard?

I hope it is clear what I explained and I wish to achieve.

Anyway, I would guess it is not possible because we are working with slices which do not have a feature for “LINKFILTER”, but I might be wrong, if anyone knows a solution I really would appreciate the help.

Thanks!
Eduardo

Hi @edulk,

You may wish to take a look at the sample app below. The slice therein is based on filter based on enum with colors. You could base your filter on enum with currency (Euro and USD) . You could even have another enum for Expenses and Revenues. You can then have a combination of all four enum values to come up with a single slice with varying conditions.

If you have multiple users, your filter table may need to have multiple rows, one each for storing each user’s filter settings.

https://www.appsheet.com/samples/Allow-the-user-to-filter-a-view-based-on-a-form?appGuidString=91266cff-e843-46b8-a42b-3d85afedb37f

Edit: Minor correction in description.

4 Likes

Hi @Suvrutt_Gurjar,

Thank you for your answer.
Actually, I do have a filter like the “red/blue” from the sample you sent me, where I can choose the “Account”, whether it would be “John” or “Anna”.

Just to confirm what you said, you mean I should create a single Dashboard and the order of my “Views” (UX) could be like that:

1 - Filter “Currency” -> choose between “EUR” or “USD”

2 - Filter “Account” -> choose between “John” or “Anna”

3 - Chart from a Slice with [Type]=“Revenues” (Both previous filters would affect what is shown)

4 - Chart from a Slice with [Type]=“Expenses” (Both previous filters would affect what is shown)

Did I understand correctly?

Another question that I’m in doubt about these Filters (interactive dashboard), if I have 3 people in the “Account” column, can I select two people simultaneously or it has to be a single selection?

Thanks!

Hi @edulk,

Yes, my reference was in response to your following requirement

In general, I believe you could create the filters that you have listed in the four points.

Regarding above, whether you wish to have charts or some other summary view such as table , I believe you should be able to do that based on slice you create.

For the above you could have enumlist for account names rather than enum, which will enable you to select multiple accounts.

3 Likes

Thank you @Suvrutt_Gurjar, I will create the multiple filters as you suggested.

Regarding the last question that you mentioned the enumlist feature in order to be able to select multiple accounts. I have a Google Spreadsheet (Table) with only the “Account” names - as shown in the picture below - and they are related to other spreadsheets (Table), so the filter can work.

I switched from “Text” to “Enumlist” only the “Account” column, but my Filter_Accounts (View) remains the same, i.e. I cannot choose two accounts simultaneously.

I changed the other columns from “List” to “Enumlist”, but it gives errors and my Filter doesn’t work anymore.

Anyway, thank you for your help and clarification.

hI @edulk,

I am sorry that I am unable to understand your current setup. In general, I believe , all these select options buttons should be in your filter table that applies filters to the slice based on those enum / enumlist selections in teh filter table.

If you are getting account names from an Accounts table for example, your expression for pulling in account names could be something like Accounts Table[Account Names] in valid_if of " Select Accounts" enumlist button in filter table.

I believe you may wish to build your filters step by step after confirming each indvidual part is working.

2 Likes