Duplicate Date on X-Axis Line Graph

[#1]

I have a line graph with a dimension "cboDate", tied into a measure of "Index Number".... What I am trying to do is get the line graph to show the count of how many individual Index Numbers for each single date.

When just adding "cboDate" as Dim and "Index Number" as measure I get a X-Axis that lists duplicate same dates but I want it to add all the Index numbers that took place on each day only. Any ideas? Thanks in advance.

[shree909]

Try this

1. Try to convert  cboDate in the script to proper date format with distinct .
2. If your creating any master calendar from the cboDate , try to take distinct and create a calendar.

If possible please share a sample app ...

[#3]

As you can see my Y-Axis is a count of "Index Numbers" that are logged throughout the day... However, each index number is attached to a date. I do not want the same date repeated on the X-Axis.

[shree909]

can you share a sample data to look into it..

[#5]

I am not authorized to.

[stigchel · Accepted solution]

A date is a so called dual field with a text representation and a number presentation. Your text presentation may be set to show a single day, but the number representation probably includes the time and this is why QV is treating this as different values.

You could use a calculated dimension like

=Date(Floor(cboDate),'DD-MM-YYYY')

performance wise it is better to create this field in the load script

[#7]

Perfect. Thank-You!