Counting Completed Date and Use Graph

KamenRider

Good day guys,

I have an illustration attached and I wonder how I can automate it with graph in Alteryx. The illustration show below counting the completed date per month since 2022.

There are other results that I wanted to be showed which is being represented below

 Below is another graph which I wanted Alteryx to create.

 Below is the sample excel raw data for your reference.

I do hope someone could help me how to do it although it is very complicated.

Thanks and hoping to hear from someone.

Kamen

Sample RawFile.xlsx

Yoshiro_Fujimori

@KamenRider ,

You can tweak the column names by the function in Dynamic Rename tool.

In the original workflow, I added IF statement to follow your sample output.

If you don't need it, just remove it as below and then you'll get what you want.

IF StartsWith([_CurrentField_], "2023")
THEN DateTimeFormat(
  DateTimeParse([_CurrentField_], "%Y_%m_%d"),
"%b")
ELSE DateTimeFormat(
  DateTimeParse([_CurrentField_], "%Y_%m_%d"),
"%b-%y")
ENDIF

For the graph, I cannot recreate your issue, but the setting is as below.

Output

I know Reporting tools are tricky and you need trial & errors to be familiar with it.

Good luck.

CountTurnTime.yxmd