-
Graph showing by month, average condition for 16 different rooms.
I need to create a graph where I show, by month, the monthly average condition of each of 16 different rooms. Each room will have 4 to 5 values for every month (one per week) and I need to take the average of that for each room and show it on a stacked bar graph. Attached is what I got started, but the issue I am having is…
-
Flagging items past today's date
Hi, I have a table where I am trying to flag all line items where the "Planned End Date" is past the current date. Is there a quick beast mode for this?
-
How to format month to show as "December" instead of "12/1/2017"??
I am pulling data from an excel file that needs to be formatted as "MM/DD/YYYY", however, when I display the data on a graph, I want the x axis to show, in this example, "December" instead of "12/1/2018". How can I make that happen?