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

[Hammad_Rashid]

Hi @KamenRider 

Please see if you can create the chart using the below links.

Best,

Hammad

https://help.alteryx.com/20223/designer/interactive-chart-tool

[Yoshiro_Fujimori]

Hi @KamenRider ,

I created a sample workflow.

You may want to play around the parameters of Interactive Chart.

Good luck.

Input

Interactive Chart

Create / Layer

Create / Transforms

↓↓↓↓↓

Style / Layer

↓↓↓↓↓

Output

[KamenRider]

Hi @Hammad_Rashid 

Can you please how I am going to start the workflow? I find it complicated.

Thanks and looking forward.

Kamen

[KamenRider]

Hi @Yoshiro_Fujimori 

Thank you for the response. Appreciate how you demonstrate how to create a graph. However can you also help how to derived those data before the start of graphing like below using my raw file. It will allow me to understand more how my data works to create the graph.

 

 

Appreciate so much your response. Thanks,

Kamen

[Yoshiro_Fujimori]

Hi @KamenRider ,

It is difficult to find the relationship between the raw data and the pivot table you provided.

For example, the raw data has only 14 rows,

while the output table has a new field "Row Labels" without definition with 19 rows.

I would say you need to provide more information.

[KamenRider]

Hi @Yoshiro_Fujimori

What we would like to do is that using the field "Turn Time" vs the field "Completed date" we will be able to create a similar result as found below.

Raw file

Sample  Result

Same also with the other screenshots, the left side refers to the "Turn Time" wherein below "Turn Time" is hoping to get all turn time less than 5 (<5) vs the completed dates and so on.

After we get those into Alteryx Conversion, we convert it to graph.

Please help me how I can translate this to Alteryx Conversion so I could also learn from it.

Thanks and looking forward for your assistance. Please let me know if you have inquiries.

Kamen

[Yoshiro_Fujimori]

Hi @KamenRider ,

For more effective communication, please consider sharing a real Excel sheet dealing with real data and pivot table.

Meantime I generated a psudo data with random number of rows and random "Turn Time".

Input Data

(You can ignore the fields other than CompleteDate and TurnTime)

Workflow

Tile tool is the key to count the rows at arbitrary range.

Output 1 - count by TurnTime

Output 2 - count by Range

Adding grand total is a different issue and you can find some useful tips on the community with keywords like "excel grand total".

https://community.alteryx.com/t5/Engine-Works/How-to-Generate-and-Format-Totals-and-Subtotals/ba-p/9...

Good luck.

[KamenRider]

 Hi @Yoshiro_Fujimori 

Thanks for the guidance. I think we are nearing the solve it. I was able to combined the workflow and the graph you have send and I have some more questions.

First, is it possible to have a uniform date. Instead of Jan, Feb and March, have it Jan-23, Feb-23 and so on?

 

I have an error in line to the graph portion. I am trying to locate in the net but I am not able to locate a solution. Please advise how can we fix it.

Thanks and looking forward for your response.

Kamen

[Yoshiro_Fujimori · Accepted solution]

@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.