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

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/