Line Charts Months vs Years and Dates Vs Months

[rammarthi]

Hi All,

I have a created the following line chart with from a date with Month(Date) on x axis and Year(Date) on Y axis. and expression as Sum(High)

A similar kind of graph I want for Days in a Month vs Months in a Year. But that is spread as show on the right hand side.

Is there a function like Dayinaquarter for Months also, so that can help me fix this.

Thanks in Advance

Ram Marthi

[Gysbert_Wassenaar · Accepted solution]

The Day() function will return the day of the month of a date. Is that what you're looking for? It looks like you're now using the date formatted as DD in the chart on the right. That means it's still the date field that's the dimension on the x-axis. You probably want to change that to the Day field if that exists or Day(Date) if it doesn't.

[rammarthi]

Using the Text of date of Date in the script does the magic.

LOAD Date,

     Text( Date( Date, 'DD' ) ) as [Day of Month],

     Month( Date ) as [Month Name],

     Year(Date) as Year,

And this is how the line chart looks like:

[rammarthi]

Yes, Day(Date) also gives the same results I just checked. Thanks for the response.