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?
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:
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.
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
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.
I’m working with ShotGrid (Flow Production Tracking) and I need to create a chart in the dashboard that shows only two sections and adds up different statuses to give the precise percentage of which VFX are complete and which are still WIP:
Shots considered “Complete” (e.g., statuses such as approved, final approved, final approved 4K)
“Not completed” shots (all others)
Is there a recommended way to perform this aggregation within ShotGrid dashboards?
It seems very similar to the TeaspoonVFX case, but I can’t get it to work. What am I doing wrong?
Hey Angie, we built a product at https://flowpilot.studio that allows you to do exactly that.
Once you build your chart (with or without the help of our AI assistant), you can simply group certain values together arbitrarily. That way, even if you have many statuses in Flow PT, you can arbitrarily group them together in the final chart and name the group however you want to.
There’s a free tier that allows you to test easily. Login uses the app session launcher, as other apps like RV.
Hope that helps!
Do you have permission to create or edit fields? The easiest and fastest way to see Complete and Incomplete shots — as a production end user who might not have any kind of Admin permissions, looking to work exclusively in FPT and not do any csv export or use any kind of outside tool — is to use two graphs side by side; one to display all the Incomplete shots and one to display all the Complete shots. You can choose different graph types depending on how you want to visualize the data.
In this example I have 4 statuses. Waiting to Start and In Progress are my Incomplete statuses, and Final and Super Approved! are my Complete statuses.
Below is an example of two vertical bar charts side by side. Both vertical and horizpontal charts work for these purposes. The one on the left has a filter to show only shots with my Incomplete statuses. The one on the right has a filter to show only shots with the Complete statuses. Totals are displayed at the bottom so the numbers can be viewed at a glance. 897 shots are Incomplete and 94 are Complete.
The pie graphs are my preferred method since they can be set up in seconds. I know that you specifically asked about percentage, and I know this doesn’t totally answer that question, but hopefully this helps!
