When I create a chart and add two filters, the first will work and the second does not affect the data in the chart. Then, when I close out of the chart and reopen it, my checked boxes in the second filter do not appear, though they are still listed in the box to the right. (screenshot attached)
This bug is not affecting all of my databases, but I need a resolution to continue creating charts in this database.
I am currently working with a table of data that is collected by date. I have three main columns of data that I'm working with.
2. Type of product
I have another table that I'm joining to create a new one that adds a column to translate each date into one of two categories (date type).
What I'm interested in accomplishing is an average quantity by product by month by date type. But the average calculation needs to be done by summing up the quantity of each product in each given month (one for each date type) divided by the number days of each date type respectively. I know how to get the query to sum up the quantity and group by product by day type, but I'm struggling with getting the averages and comparing ave quantity by date type.
I thought I had a solution and the calculations looked right, but it wouldn't allow me to save the query because I exceeded the allowed amount if queries over queries. Then I had another solution that I thought would work but it timed out trying to run.
I should note that an issue is that there are multiple products in the database, therefore on one single date there could be 10 products sold that day. so averaging quantity is difficult because the query is averaging based on number of total rows.
For some reason, one of my dashboards won't let me make any modifications to it and save? I get the "do you want to save before closing?' and I say yes and the dialogue box just stays there. I try to do a "save as" right after I open that dashboard and I get the dialogue box that seems to let me name the new dashboard, but it won't let me save. The dialogue box just stays there unless I hit cancel or no.
As I'm creating reports for a client, let me share with you what we're doing.
1. We have one database with several columns of information 2. We have 20 markets that have information inside this database 3. We have to create 20 individual dashboards from the information on this database. 4. Inside our database, we have folders - one for each market. 5. Each folder has about 18 reports (each folder contains the same 18 reports, just filtered differently)
So, while we can't export the dashboard as a PDF for our client who insists on a paper version in addition to his online version, we are able to export all of the individual charts to an interactive PDF (which is great). However, when we go to export to multiple views there's something that is very time consuming. The box where you select which charts you want to include in the PDF is sorted in the order in which you added the tables and reports.
I'd like to see instead, that menu showing my folders (with the expansion root) so that I can quickly go to the folder that I organized already and select only those charts for export.
So in otherwords, when you export multiple view PDF, instead of seeing all the files, I want to see my folders, then be able to expand those, then select all of my files. This would save me about 5-10 minutes each time I need to make a new PDF. That adds up, especially when you have 20 markets - you're looking at about 100-200 minutes each time I need to make a PDF
Any chance that's something that you could make happen easily? (and quickly of course :-))
I currently have a database that I need to create multiple charts filtered by market. All of the charts are identical, I just change to of the filters and then I have the next market's set of charts. The only way I've been able to copy charts (reports) is to do them one by one as a "save as" and place them into another folder.
Is there a way for me to copy ALL of the charts inside a folder at once and put the copies in a new folder?
Please help, as this would save me a tremendous amount of time.