Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Plot a graph against date

Jerin_jaj
7 - Meteor

I have a requirement to plot some value according to dates.

On X- axis there will be dates and Y-axis will be the values. I am using the Chart tool but i cant plot dates on it.

Is there any way to do this?

 

 Required graphRequired graph

 

1 REPLY 1
CharlieS
17 - Castor
17 - Castor

If your date field are formatted as datetime field types, then converting them to string fields will allow them to be used as graph labels. You can convert to/from a datetime field using the datetime tool (in the Parse tool category). If you use a different date format and are worried about keeping your records in order: use a RecordID tool and a sort tool to retain the original order.

 

In the attached example, I entered a string field, converted to a datetime type and back to string before using them for graph labels. I also recommend using the Charting tool and not the deprecated Chart tool. 

Labels