-
Can a card be in details view while on a design dashboard?
I have a dashboard built that contains a large graph that has several quick filters on it. Id like those filters to be visible while viewing the dashboard. I don't want the end users to have to open the cards details view to filter the graph. Does anyone know if this is possible?
-
Can you do a running total in a pivot table?
I have some data that I'm trying to run in a pivot table. I've got it laid out the way I need it, but I would like to see a running total. This is what I have currently, If you look at the 0ME unit, it should read 96.77% | 96.77%| 97.23% | 97.23% | 100.00% This is easy to do in a graph with a running total, but I can't…
-
Can you turn a date range into each individual date in the range?
I have a start date and end date with a total sum of hours to work. These are each 10 days with an average of 3.2 hours and 2.8 hours respectivelivy. Is there a way i can display each indiviudual day of the date range with the work per day? Something like this?
-
Can you fill null pivot table cells with the previous non null value?
I'm building a pivot table with a running total. The running total is working well, but the data is leaving some null cells. I would like to fill those null cells with the last previous non null value, is this possible? It would make the table much easier to read and it would just look better. Here is an example of what I…
-
Setting a duplicate value in a column to null or zero
I have a dataflow where I'm joining projects to their respective tasks. Each project will have a large number of tasks associated with it and a planned/actual cost for the project. This results in many duplications of the cost and task data. Can I somehow set all duplications, after the first set, to 0 or null without…
