Forum Discussion

SchmitKS's avatar
SchmitKS
Regular Visitor
6 years ago
Solved

Quickinfo doesnt match the x-Axis

Hey there,    I am trying to visualize the amount of overdue and intime taskes im comparison with new tasks coming up each month. I set the due date to the end of each month. Having this in the cha...
Need Help
  • SchmitKS's avatar
    SchmitKS
    6 years ago

    Hey Miguel, 

     

    thanks for your response! 

     

    I used a calender table which was linked to the dates in my data table 😉 

     

    I found out, that I had to change the type of my x-Axis to Category. 

    Now it works 🙂 

     

    Best regards, 

     

    Kim 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi SchmitKS ,

 

Are you using a calendar table or a date column from your data table?

 

If you are using a date column from your dataset you will pickup the highest value on that month that is withing the selection you made because your dataset doesn't have those dates.

 

In the case of time values the best option is to create a calendar table with unique values for each date starting on 1 of january until 31 december (start and ending year is as you need) and that will give you the month end as you need.

 

SchmitKS's avatar
SchmitKS
Regular Visitor
6 years ago

Hey Miguel, 

 

thanks for your response! 

 

I used a calender table which was linked to the dates in my data table 😉 

 

I found out, that I had to change the type of my x-Axis to Category. 

Now it works 🙂 

 

Best regards, 

 

Kim