Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not sure why you can use what I mentioned above???
Count({<DateField = {"$(='>=' & Date(AddMonths(Max(DateField), -12), 'YourDateFieldFormat') & '<=' & Date(Max(DateField), 'YourDateFieldFormat'))"}>} [Incident ID])
Sunny, The above expression is not working
Sunny can you please help me i will attach my sample data file ....
Thanks in advance,
Chinnu.
Sure
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
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)
Thanks Sunny for resolving the issue
No problem at all
I am glad I was able to help.
Best,
Sunny
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.
What is your month field look like?