Forum Discussion

quincy_p's avatar
quincy_p
Advocate 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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi quincy_p,

 

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

 

Best,

Prasanna Kumar