I’ve been building a Canvas page for the project I’m supervising, and I have my own set of data I like to look at, but the producer would like to have a boiled down version. He says the report was generated from Flow in the past, in its early iterations, I suspect that the report was generated from Excel – using data from Flow
As I said, I’ve created a bunch of widgets, but for the life of my, I can’t figure out how to query for the Total Shots versus Final shots based on Episode – in a spreadsheet type grid, and then have a graph with just the Total Shots - Per Episode with the number of Finals.
Does anyone have some insight in how I can query, for example, the number of shots in an episode and throw it into a field? Of a widget?
It seems so simple, and yet, its confounding me.
Hi @TeaspoonVFX
This might just be a starting point for you but you could create a couple query fields on the episode entity. One for total shots and one for the finals:
Here is the total shot query:
And the final shot query:
These are super basic ones but they will get the data listed. The Show Totals could be done on the project entity level along with the “Pace” examples in your report. Then you’d just need to create a canvas page and display the grid widgets with the data you want.
I’ll have a think about the percentage complete fields but I’m sure someone here has the knowledge on the top of their heads for ya.
Hope that helps a little
Actually as soon as I hit “reply” I remembered an option for the percentage complete field:
Here is the query:
Again, just basic options and you can make it as complex as you like.
Thanks so much, Pete. Worked like a charm.
Oddly (or maybe not so oddly), If I try to map the Total Shots or Final Shot Counts to a Graph Widget – those fields are unavailable.
Yeah, graphs are essentially queries themselves so you can’t access your custom queries there unfortunately.
But you can graph the shot entity by episode and group the results by status.
It would kind of get you what you’re looking for but instead of all shots vs finals it would graph all shots by the different statuses used. Maybe stacking them would offer an easier to read view of the totals for each episode? Just have to play with it a bit.
If I think of something that gets closer to your original example I’ll follow up if no one else has
Here is what that graph would look like:
And here are the graph settings:
Thanks again, Pete – this is perfect. I had a graph like this, but since I have more status values than “In Progress” and “Final”, I have a few more colors.
