MUKTA Dashboard comes with around 21 KPIs visulization covering the action items, tracking the status of attendance, expendutire and payments.

SLA Breached

Estimate Approval

1. Number of estimates that are created in the selected time period but have breached their SLA is respective workflow statuses.

2. Ex. Estimate created on Jan 15 (timeline selected is Jan 12-18), SLA is 5 days for one particular state. From Jan 21 on-wards till date this will be counted as SLA breach.

3. Parallel there could be other estimates in other workflow statuses too which have their respective SLA breaches.

4. All these will be accumulated to form SLA breach of Estimates.

5. If estimate is moved to next workflow state, this count will go down until the breach happens again.

6. All SLA breaches below KPIs follow same Logic.

Contract Approval

Includes only until contract issuance. Contract Acceptance by SHG breach is not counted as SLA breach for this metric.

Muster Roll Approval

Muster roll approval breaches SLA.

Bill Approval

Only for Purchase Bills in V1.

Leadboard: Information in tabular form.

Status

Projects

1. Only three statuses will be shown for projects.

   1. Created - All projects that are created in selected time period

   2. In progress - Number of Projects that are created in the selected time period but Work Order(Contract) is not closed yet (Which means project is officially not closed)

   3. Closed - Projects that are created in the selected time period and Work Order is closed in the past already

2. No Hover Text

Estimates

1. Only three statuses will be shown for Estimates.

   1. Created - All estimates that are created in selected time period

   2. Yet to Approve - Number of Estimates that are created in the selected time period but estimate is not finally approved (Didn't reach final status)

   3. Approved - Number of Estimates that are created in the selected time period and approved in the past

2. No Hover Text

Work Orders

1. Five statuses will be shown for Contracts.

   1. Created - All Contracts that are created in selected time period

   2. Yet to Approve - Number of contracts that are created in the selected time period but contract is not finally approved (Didn't reach final status)

   3. Yet to Accept - Number of contracts that are created in the selected time period but not Accepted by CBO as of Date

   4. In Progress - Number of contracts that are created in the selected time period and Accepted by CBO in the past but not closed yet, irrespective of contract closure date.

   5. Closed - Number of contracts that are created in the selected time period and closed in the past

2. No Hover Text

Muster Rolls

1. Only three statuses will be shown for Muster Rolls.

   1. Submitted - All MRs that are created and Submitted (Combined action) in selected time period

   2. Yet to Approve - Number of MRs that are created in the selected time period but Approval is pending (Didn't reach final status)

   3. Approved - Number of Estimates that are created in the selected time period and approved in the past

2. No Hover Text

Payments

1. Default line chart component

2. Behavior same with respect to filters

Amount Paid by Bill Types

1. Amount Paid by Bill Type Aggregated by Months.

   1. IF JIT integration is done by the time you are reading this, KPI should be the actual Amount transferred (Response from JIT) by Bill Type aggregated by Months.

   2. IF JIT Is not done by now, Bill Final State (Payment done)by Bill Type aggregated by Months.

2. On Hover show: All 3 KPIs in that vertical column with actual Amounts

Wage Payments Vs Attendance

1. Payments are the same as represented in the bar chart and filtered only by wage bill.

2. On Hover show: Month and Actual Amount

3. The number of Approved Person Days considered in Muster rolls created for Wage seeker Bills amounting to above KPI.

4. On Hover Show: Month and Actual Person Days

Payments By Gender

1. Table showing payments made to Wage Seekers by gender in the selected time period. Considers wage bills where final approval status and beneficiary status reflect payment done.

2. Average days of employment - Average Approved Days by gender from muster rolls created in a selected time frame.

3. Average Payment - Average Payment made by gender in the selected time period where the status of beneficiary turned to paid.

Context

This is an Umbrella story for MUKTA Dashboard. Gives high level description details along with standard components.

V1 Dashboard has 25 KPIs - 8 Simple numbers and 17 in Charts Design

Standard components on dashboard

Date Filter

District Filters

1. Should filter the dashboard data by selected District.

2. Multi select should be enabled.

ULB Filters

1. Should filter the dashboard data by selected District.

2. Multi select should be enabled.

3. Should be drilled down from District that is selected.

Denomination

1. Cr, Lac, Unit as per DIGIT standard

2. Share

3. Email, Whatsapp as per DIGIT standard

Download

1. JPEG as per DIGIT Standard

Roles

1. Define a single role called “MUKTA Dashboard Viewer” whoever has that access should have Dashboard link on left navigation menu and home page card links.

2. Use same dashboard Icon as per DIGIT standard.

3. Clicking on link will land user directly on dashboard Home with no filters applied.

User Acceptance

1. All filters, Denominations, Share and Download options to work as standard and expected.

2. All Cards will by default have menu individually(three dots). This will download image or share that card in that visualization to JPEG (Default DIGIT behavior)

Projects Delayed

1. Count of Projects where WO start date is in the selected date range and WO end date + X days is less than todays date. Let X be configurable.

2. For ex. Selected time period is Jan 1 to Jan 15. WO start date is Jan 7th, end date is Jan 31, X is 7. From 8Feb onwards if project closure is not done, this project is considered delayed.

3. On Hover show “ Contract created in the selected time period but not closed till date”

Pending Bills

1. Count of Bills that are created (Automatically or manually) in the selected date range and but current status(as of today) is not Paid/Payment done (Whichever is final state of Bill)

2. Considers all types of Bills

3. Show Amount as well of these bills as designed in mockup

4. On Hover show “ Bills created in the selected time period but payment is not done as of today”

Work Orders Not Issued

1. Number of Projects that are created in the selected time period and Work Orders are not yet created. (PS: Both are create dates only though text says issued.)

2. On Hover show text “ Projects created but Work Orders not created”

Muster Rolls Not Created

1. Count of weeks across all work orders that are in progress (Accepted by SHG) but Muster Roll is not created.

2. If Contract start date is Jan1st (Mon) and user hasn't created muster rolls until Jan 31, Number of Muster rolls not created are 4 for this project. If User Submits any 2 of them on Feb 1st, then remaining 2 should be shown.

3. On hover show “Work weeks completed but muster rolls not submitted to ULBs”

Expenditure

By Project Type

1. Projects that are created in the selected time period by project type

2. Show total project count within the PIE.

3. Switching to Amount should show same split by Amount instead of Count

4. Default Action on Hover

By Bill Type

1. Amount Billed (created) by Bill Type in the selected time frame. May not be approved or may be rejected also in that time-frame.

2. Show total Amount in the PIE

3. Switching to number should give number of bills the above KPI refers to while calculating amount.