Performance Analytics - Catalog Tasks created CURRENT MONTH LAST YEAR VS CURRENT MONTH THIS YEAR

chatsaurav19
Tera Contributor

Hi All,

 

I have never used PA tool so need some guidance as to how to create a widget using PA to show 'Catalog Tasks created CURRENT MONTH LAST YEAR VS CURRENT MONTH THIS YEAR' on the dashboard, for one particular Catalog Item.

 

Ex. Jan1 till Aug31 2022 v/s. Jan1 till Aug31 2023

 

Thanks and Regards,

Saurabh Chatterjee

1 ACCEPTED SOLUTION

Hi @chatsaurav19 ,

 

1. Create a report based on the table "catalog task [sc_task]

 

AndersBGS_0-1694085502059.png

 

2. Choose a times series report e.g. column:

AndersBGS_1-1694085536713.png

3. Chose to configure the per as "month" and trend by "created":

 

AndersBGS_2-1694085585256.png

4. Set the conditions as:

AndersBGS_10-1694086027963.png

5. Save the report

6. add an additional dataset to the report: 

AndersBGS_4-1694085677293.png

7. Chose catalog task [sc_task] in the new dataset:

AndersBGS_5-1694085736802.png

8. Chose column once again

AndersBGS_6-1694085763142.png

9. Configure the dataset as below:

AndersBGS_7-1694085804947.png

10. set the conditions as below:

AndersBGS_11-1694086106110.png

 

11. press save dataset

12 the result:

AndersBGS_12-1694086138687.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

5 REPLIES 5

AndersBGS
Tera Patron
Tera Patron

Hi @chatsaurav19 ,

 

Why utilizing PA? When you want to measure one particular catalog item by "created", then you can just do it through the report designer. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

 

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS ,

 

Thank you for your reply! Can you please share a screen shot as to how this can be achieved using report designer?

 

Regards,

Saurabh C

Hi @chatsaurav19 ,

 

Did you get your issue resolved or do you still need a screenshot?

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Hi @AndersBGS ,

 

Not yet. It will be helpful if you could share a screen shot for the same.

 

Regards,

Saurabh