Remove duplicate date on x axis bar chart

Prabhu — Sat, 16 Nov 2024 03:57:48 GMT

Hi All,

My bar chart dimension is displaying repeated MonthYear values. I want it to be displayed only unique MonthYear values.

Below is my chart dimension

=DATE(DATE#(Open_Time,'DD-MMM-YYYY'),'MMM-YY')

I tried this as dimension, but no use: Date(Floor(DATE#(Open_Time,'DD-MMM-YYYY')),'MMM-YYYY')

Please help

Re: Remove duplicate date on x axis bar chart

dplr-rn — Wed, 03 Apr 2019 13:58:17 GMT

use monthstart function
change your dimension to
DATE(monthstart(DATE#(Open_Time,'DD-MMM-YYYY')),,'MMM-YY')