First day of the month only data

[Anthony stark]

Hi Guys,

 

I have some data that captures maintenance data all year round. I am trying to create a line-chart that captures the data for the first day of ever month only (all year round). How do i create the line-chart in a way that it only polls the data (in percenage) for the first day of every month only

 

Thanks in advance

[Anthony stark]

Any help with this

[Kirsten Smith (she/her)]

You could create a new column with an expression like:

 

Day([Date])

 

then set a filter or Show/Hide to only show data where this column = 1

[Anthony stark]

Thanks KirstenS can you elaborate more on this solution i didnt quite get what you meant. What date would be in the proposed ([DATE]) column

[Naveen Tibco]

Hello,

 

----> you can add calculated column with expression  -----> Day(date) as "DAY"

 

---> go to line chart  ---> properties ---> data ---> limit data using expression ----> [DAY] = 1.

 

 

 

Thanks 

 

Naveen

[Kirsten Smith (she/her)]

I'm assuming that your data has a column for dates, you describe wanting "captures the data for the first day of ever month only". That's the [Date] column.

[Anthony stark]

Thanks for all the input, i appreciate it