Forum Discussion

quincy_p's avatar
quincy_p
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Create Dummy Data within a Table

Hi all - I am having a problem. I am trying to build a tool that will show us our planned services on specific assets.   The way we do this is via Work Orders and their Scheduled Date that are link...
Need Help
Tutorial Requests
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi quincy_p Yes, it is possible to create dummy work orders and populate Try these please 
    Check for Blank Work Orders: Use a calculated column to assign dummy work orders for blank values.

    Work Order [Name] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   "WO-Dummy-" & WorkOrders[Component] & "-" & RANKX(ALL(WorkOrders), WorkOrders[Component]), 
   WorkOrders[Work Order Name])

    Assign Scheduled Dates: Add a calculated column to generate dummy dates if the work order is blank.

    Work Order [Scheduled Date] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   DATE(2025, 1, 1) + MOD(ABS(HASH(WorkOrders[Component])), 365), 
   WorkOrders[Scheduled Date])

    If this post helped please do give a kudos and accept this as a solution
    Thanks In Advance

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

Hi quincy_p Yes, it is possible to create dummy work orders and populate Try these please 
Check for Blank Work Orders: Use a calculated column to assign dummy work orders for blank values.

Work Order [Name] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   "WO-Dummy-" & WorkOrders[Component] & "-" & RANKX(ALL(WorkOrders), WorkOrders[Component]), 
   WorkOrders[Work Order Name])

Assign Scheduled Dates: Add a calculated column to generate dummy dates if the work order is blank.

Work Order [Scheduled Date] = 
IF(ISBLANK(WorkOrders[Work Order Name]), 
   DATE(2025, 1, 1) + MOD(ABS(HASH(WorkOrders[Component])), 365), 
   WorkOrders[Scheduled Date])

If this post helped please do give a kudos and accept this as a solution
Thanks In Advance