CLewis
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
Filter by two values on same widget
Anyone know how I can filter two values independently? In the chart below the first 4 bars are from my "days in R/I stage formula. The next 4 are related to the Insulation-Prime formula. Each formula has a filter built in to only look at jobs from the stage they are in. But I also want to be able to filter these by different numbers. "Current days in R/I" should only show jobs over 15 days. Where "Current days in insulation/prime" I want to see anything over 10 days.1.8KViews0likes1CommentRe: Using answer to a calculation within another calculation
No this gives me the same result as I have without ALL added in. Its sounds like this should be an option but maybe its the placement off ALL at the end of my filters causing an issue? I am not sure. It is still calculating on a row level so my job 9761 is counted as 1/1 instead of counting all accolade models sold prior to drafting which should be 9/ 13 total Accolade models sold6.5KViews0likes1CommentUsing answer to a calculation within another calculation
Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total number of sales. This then shows the percent sold prior to drafting for each of our models. (count([UniqueJob]), [SoldPriorToDrafting], [Years in FinalSaleDate]) / (count([UniqueJob]), [Years in FinalSaleDate]) The problem is I don't want the calculation to run first on the new widget I just need to use the number from the pivot table above as the other widget shows each individual job within the model. The calculation doesnt work when looking at it in this view.6.6KViews0likes4Comments- 2.7KViews0likes0Comments