Skip to main content
Navigator | Tier 3
January 2, 2022
Solved

Question Regarding Analyze Package

  • January 2, 2022
  • 16 replies
  • 189 views

Hello, I am following the Managing RPA Reports Using Automation 360 video, I have encountered the following issues and would appreciate any help:

Question1: when I run the whole bot, it stops at line 5 with the following error, but I follow the exact same step as the video

demo excel file 1微信截图_20220102200621demo bot

微信截图_20220102200713my downloaded excel

微信截图_20220102200853my bot 微信截图_20220102200942my error

image.pngQuestion2: if i skip the date, the analyze still doesnt work

it shows the bot run successfully but the progress bar isn't complete,

also I can't generate a dashboard from 'Analyze Task Bot'

would

imageimageimageimageQuestion3: What is the 'Business Analyze Status' in Analyze:Close

I don't see it in the analyze package documentation.

 

Would appreciate any help, Thank you! 😀

    Best answer by ChanduMohammad

    Hi @Yuwei Yan​ ,

     

    Even I am using Community Edition of CR, as above example have created a bot and captured a single variable for Analytics. Once the bot execution is completed >> Click on Analyze Task Bot and it took me to the Bot Insights i.e Business Dashboard, PFB Screenshot for your reference.

     

    Note: You have restricted access in CE i.e you cannot publish the Dashboard still you can play around.

     

    CE BotInsight

    16 replies

    Most Valuable Pathfinder
    January 3, 2022

    Hi @Yuwei Yan​ ,

     

    1. In Line 5 can you update Custom Format as "dd-MM-yyyy" and try again, this resolves the Line 5 issue.
    2. Business Transaction Status : Whether you want to capture Success or Failure Business Transactions, update as per your use case.
    3. Just created a very sample bot and able to see the Bot Insight Dashboard using Community Edition of CR, PFB Screenshot for your reference. Once you run the bot click on 3 Dots and Analyze Bot which will take you to the Bot Insights of this bot.

    Bot Insight Navigation 

    Bot Insight 1Bot Insight 2 

     

     

    Chand
    Ashwin A.K
    Navigator | Tier 3
    January 3, 2022

    Hi @Yuwei Yan​ ,

     

    Could you try displaying the $Record_var{Date}$ in a Message Box to check what the format of the incoming date is? This is to ensure that the format provided in the conversion is accurate.

    Also, you can't access the Business Dashboard if you are a Community Edition user.

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Vera 7672Author
    Navigator | Tier 3
    January 3, 2022

    Hi Ashwin,

    The message has the following(which is the same as in excel), what shall I do next? imageBtw, would like to double-check with you, so the community edition can't access the following?

    image

    Vera 7672Author
    Navigator | Tier 3
    January 3, 2022

    Hi Chandu,

    1. Tried dd-MM-yyyy(and other formats) seems still doesn't work. image2.May I confirm with you, if I have this following record, it is regarded as a business transaction, right? and it is also a successful transaction? because all columns I want to analyze have value? so a failure business transaction means at least one column I want to analyze is missing value? Thank you!

    Vera 7672Author
    Navigator | Tier 3
    January 3, 2022

    Hi Chandu,

    3.followed as you suggest, still cannot access; is it because I am the community edition(like below Ashwin said)?

    imageimageimageimage

    Ashwin A.K
    Navigator | Tier 3
    January 3, 2022

    Hi @Yuwei Yan​ ,

     

    The format is MM/dd/yyyy, could you try passing that in and see if the conversion succeeds at line 5?

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Vera 7672Author
    Navigator | Tier 3
    January 5, 2022

    Hi Ashwin, sadly it's still not working. btw i think the date should first and month in the middle?

    Ashwin A.K
    Navigator | Tier 3
    January 5, 2022

    Hi @Yuwei Yan​ ,

     

    Could you please try that as well?

     

    dd/MM/yyyy

     

    Kind Regards,

    Ashwin A.K

    Blogs at TheCodingTheory - https://www.thecodingtheory.com
    Most Valuable Pathfinder
    January 5, 2022

    Hi @Yuwei Yan​ ,

     

    When you click on Analyze Task Bot are you able to access Bot Insights?

    Chand
    Vera 7672Author
    Navigator | Tier 3
    January 5, 2022

    Alright, I see!