Dashboard from one table

Hi, I have a Device table and one column in that table is the Customer the device is associated with. I chose not to have a separate customer table for this one field but instead use suggested values to eliminate duplicates. The Devices table also has a field that I will call Version.

I would like to create an interactive dashboard to allow me to select the customer and see a pie chart of the versions. I have the frame work of this working but the chart in not interactive with the table.

I have a slice of the Devices table that just gives me the unique Customer names.

I have a table view based upon this slice. I also have a chart view based upon the Device table using the Version as the aggregated column

My Dashboard view (With Interactive enabled) is just these two views but as I say at the beginning, selecting a customer in my table view has no impact on the chart.

Any suggestions?

I believe you may wish to share the column structure of the table with a few representative rows of dummy data. This will enable community to revert with appropriate solution.

It sounds that you wish to have a pie chart of versions a customer has. However you may wish to mention if a customer can have many different devices and in turn many versions for each of those devices for example.

The table:

And some sample data:
image

My slice to get the unique customer names:
image
([_THISROW] = MAXROW(“Device”, “_ROWNUMBER”, ([_THISROW].[Customer] = [Customer])))

My Dashboard View is simply two view:
Customer List
Firmware

“Customer List” is based of from “Unique Customer (Slice)” and just shows the customer column in a table view

“Firmware” is a chart view based on the Device table. It is an aggregated donut chart on Version

I hope this gives a bit more insight.

Thank you very much. I may be missing some point but Version column is not in the sample data. Could you add it?

Also could you share how "Firmware Chart"is constructed. There is Device category column. Does one customer have only one device (category) and associated versions ?

Looks like the image is cropped when I paste so I have created some new data and will attempt to paste again
image

Here is the Chart view:

Each Device only has one Customer, one Device Category and one Version

Thank you. I believe you will need to add another small filter table containing names of the customers to filter the version rows for that customer.

This is required because, I believe, the row selection based interactive dashboard will work if you have all the values of the chart are in same row. However in your case the versions for a customerare spread over multiple rows.

Please take a look at the following sample app to get an idea on applying filter to the data.

The sample app also has interactive dashboard, even though not interactive. The filter table has options Red/Blue for colors. You will have selection of customers. You could have valid_if of the filter table selection column with customer names drawn from your Device table.

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

Many thanks, that worked!

1 Like