Hi everyone,I'm working on a widget in Sisense that analyzes driver activity, and I'm trying to calculate the percentage of each driver's total trip time that occurred during their scheduled shift.I have the following fields:shift_alignment – categorizes each trip as "Before Shift", "During Shift", "After Shift", or "No Schedule Found"Total trip_duration_minutes – the duration of each trip in minutesI want to build a custom formula that calculates:(Total trip time during shift) ÷ (Total tr...

Hi danielrabinovit This is a classic case for a measured value which is a formula syntax in Sisense that allows you to filter a specific value or calculation. You can then create more complex form,ulas based off of multiple measured values and this way to basically create a % calculation where the numerator is filterewd differently than the denumerator. In your case you will need to create a formula which filters the numerator to "During Shift" and the denumerator to ALL shi...

Formula for % of Day Driven Within Shift | Help and How-To

MoreDiscussions

Formula for % of Day Driven Within Shift | Help and How-To | Sisense Community