How can I display a simple line graph using my comment topics with my dates for everyday for a year? | XM Community
Skip to main content
Solved

How can I display a simple line graph using my comment topics with my dates for everyday for a year?

  • July 16, 2020
  • 2 replies
  • 32 views

Forum|alt.badge.img+1

If I want to create a simple line graph using my comment topics with dates for everyday for one year, I cannot create a topic for everyday as the maximum amount of topics I can have is 350. I have tried to use the raw data itself, but it doesn't sort automatically, I have to sort it manually if I want the dates in order. Is there a way to use everyday for a graph while also having it sort automatically?
Current Date format: M/DD/YYYY ex. 7/16/2020
image.pngEdit (8/7/2020) - Figured out solution

Best answer by MMQT_Team

Edit: Found Solution - SOLVED

2 replies

YASH1T
QPN Level 2 ●●
Forum|alt.badge.img+6
  • QPN Level 2 ●●
  • July 19, 2020

MMQT_Team , Why don't you map the comment field as a date field and specify the custom date format? using this you can plot a graph with metrics "Count" and Date field on X-Axis

If creating topic is necessary because of garbage data, add extra zero before month (i.e. 07/16/2020).


Forum|alt.badge.img+1
  • Author
  • Level 1 ●
  • Answer
  • August 12, 2020

Edit: Found Solution - SOLVED