How to Easily Copy/Paste or Extract Multiple Results from a Dash?

[interrobang]

Hi everyone,

Working on a dash for which the goal is to automate manual data entry which needs to take place over 100s of spreadsheets.

Data in question is a stats table showing relations on an xy grid, to be copy pasted into a spreadsheet. Some grids are tiny, eg. 4x4 but some are truly ridiculous.

The dash is taken care of with db data ingested daly and outputing results to a filterable stats table. People can filter by their specific spreadsheet output needs and copy paste straight into excel. This is mostly working and saving tonnes of manual info gathering but unfortunately, for the unlucky people with the ridiculous grids eg. 100x1000. copy/pasting off the dash with multiple pages becomes another problem.

Question being, what efficient ways can i get multiple people the most usable access to their specific filtered extracts from one dash table? eg. making it fully self-service for all.

Ideally it'd be great if automatically a report or something just did everything and mailed everyone, but that creates a new nightmare, with 100s of unique extracts & 100s of people to receive them...

I figure i need some way everyone can visit the dash, dropdown select their id which filters their specific table grid, and they get an option to either automatically copy the whole table (click a button its copied), or download a csv extract or something.

Is anything like this possible from a dash? Any ideas?

[ITWhisperer]

Depending on how your dashboard is constructed, your users may be able to download a csv of the results from a table. If it is unavailable / greyed out, it could be because it is saved search or derived from a base search. In this instance, they may be able to open the search in a new window and download the results from there, however, I suspect you may not want to expose you users to this capability.

[interrobang]

it's a base search with stats count & xyseries table of data from sql. with a dropdown to filter by the user-id column, which will filter the results specific to the individual user's copy/extract needs.

no options for anything atm, only 'export to pdf' which is no use.  same when opening the panel search directly... could this be disabled? or need a plugin or something? my searching isnt turning up much useful in the way of csv extracts

[ITWhisperer]

For the panel, do you have an export option?

[interrobang]

Nope. Do have a power-user account, guessing that means those export options may need higher access, or currently admin disabled or something?

[ITWhisperer]

A standard user would have access to the export capability, unless your administrator has removed the capability. Please consult with your administrator.