Year and quarter data representation in a bar chart

[chinnu123]

Hi Community,

I need to represent a last 12 months data and last 3 months data in a same bar chart.

can any one help to solve the issue please

Thanks in advance,

Regards,

Chinnu.

[sunny_talwar]

Not sure why you can use what I mentioned above???

Count({<DateField = {"$(='>=' & Date(AddMonths(Max(DateField), -12), 'YourDateFieldFormat') & '<=' &  Date(Max(DateField), 'YourDateFieldFormat'))"}>} [Incident ID])

[chinnu123]

Sunny,  The above expression is not working

[chinnu123]

Sunny can you please help me i will attach my sample data file ....

Thanks in advance,

Chinnu.

[sunny_talwar]

Sure

[chinnu123]

Sunny I am  attaching sample data

I need to display bar chart based on count of incidents for the past 12 and past 3 months respective to the group.

Thanks in advance

[sunny_talwar · Accepted solution]

This?

Script:

Table:

LOAD Group,

    Incident,

    Date as TimeStamp,

    Date(Floor(Date)) as Date,

    Time(Frac(Date)) as Time

FROM

[Sample year and quarter.xlsx]

(ooxml, embedded labels, table is Sheet1);

Bar Chart:

Dimension: Group

Expressions:

1) =Count({<Date = {"$(='>=' & Date(AddMonths(Max(Date), -11)) & '<=' &  Date(Max(Date)))"}>} Incident)

2) =Count({<Date = {"$(='>=' & Date(AddMonths(Max(Date), -2)) & '<=' &  Date(Max(Date)))"}>} Incident)

[chinnu123]

Thanks Sunny for resolving the issue

[sunny_talwar]

No problem at all

I am glad I was able to help.

Best,

Sunny

[chinnu123]

Hi Sunny,

Sorry for asking again and again

The above query helps me more but can you give me  a query by using month field instead of date field.Because i need to rollout a data by using month not date.

Thanks in Advance,

Regards,

Chinnu.

[sunny_talwar]

What is your month field look like?