-
Change row report to sheet summary report?
Hello, is it possible to change a row report to a sheet summary report? So that i can keep the same link because i have it linked to on several other dashboards. I'd update the criteria too. Thanks!
-
How to generate a report for duration (sum hours) to generate a widget.
I am trying to capture the sum of duration (hours) for multiple rows. When i generate a row report and select the column and summarize it to sum, the total displays 0. I can get it to count the number of rows with data entered. Is there a way to generate this data to extract to a widget for a dashboard?
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
How can I make a graph from a report in the Portfolio level?
It appears that I can only make a graph of the whole report instead of only one column. Is this possible to do? If not, do I need to make a sheet of the data of every single column of the portfolio? For example: I need a graph of the column "Responsible area" of the portfolio, to get the data of how many projects has each…
-
How to create a chart from a report!
Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me select anything. I read that you needed to have a summary section and a group section, so I included both, but I still can't…
-
Send report as an attachment - hidden columns
Hi, If a report is set to be sent as an attachment in an Excel file (File > Send as Attachment....), will it include the hidden columns? Regards, Joaquin
-
Reports: Group By Label Display Issue
If I make my primary column an Employee ID and want to make that column smaller, it cuts off the name/label of the column I am grouping by in the report. Is this a product feature upgrade that needs to happen or a glitch? It is super inconvenient and makes my reports look very ugly when there is a ton of space left after a…
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
How can I click into a report in a dashboard and have it bring me to the sheet?
Is there a way to be able to click into a row in a report on a dashboard and it brings you back to that specific sheet? Not to the report, but the sheet that the row was created from? So far I can only find out how to go back to the report. Is there even a way to do that?