Hi All,
I am creating a Mini chart using Bar to show ticket raised trend for the past 6 months.
This month the count is more than the Previous month. But if you see the mini chart, there is no such indication as part of bar chart representation.
If I use Sparkline this tells me that the count of ticket is reduced.
Diff column shows - Difference between MTD and LMTD.
Green color tells which month being highest.
Red color indicates which month being the lowest.
Expression to show trend:
count({$<Year=, Month=, Day=,
DateKey={">=$(=Floor(Monthstart(Max(DateKey),-5)))"}>}
distinct Txt_IssueID)
For MTD:
count({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date))))<=$(=date(max(Date)))"}>}
distinct Txt_IssueID)
For LMTD:
count({$<Year=, Month=, Day=,
Date={">=$(=date(monthstart(max(Date),-1)))<=$(=date(addmonths(max(Date),-1)))"}>}
distinct Txt_IssueID)
Please suggest.
