how to show data for ytd and current month

[#1]

I have a gauge chart that shows my %SLA for the current time period, in this case from 1/1/2013 to present day.  I'd like to create a text field down below this chart that shows the %SLA for the current month to date.  Has any one done this?

[#2]

The data appears as 3 letter text or Mmm

[krishnacbe]

Ok. 'Jun' month data you have it your data model, because we are comparing the current month as Jun.

create a variable as Max(Month(ROW_ADDED_DTTM)) and pass that variable to your expression

[krishnacbe]

Share me the qvw so that will be easy to troubleshoot the issue.

[#5]

What do I need to do to share the QVW with you?

[krishnacbe]

in reply editor dialog, click on Use Advance editor, there you will be able to attach the qvw.

[#7]

Apparently I do not have that feature.  This is all I see:

[effinty2112]

Hi John,

                    You may wish to consider adding a line like this to your load script:

if(DayNumberOfYear(InvoiceDate)<=DayNumberOfYear($(vToday)),1,0) as InvoiceYTD

This will give an easy to use flag you can put in expressions or set modifiers.

You can pick any year and aggregate on the measures with the flag = 1 and you will get the YTD figure to compare with the current year. You can add flags for MTD and QTD in a similar fashion.

Kind regards

Andrew

[krishnacbe]

Hi,

PFB the place check whether you get this option or not. Hope you are reply from inbox.. please try to reply from original post

[#10]

QVW is attached

[krishnacbe · Accepted solution]

Here you go. Please validate the data.

below is the expression

=num((sum({<CRCaseYear={"2016"}, CRCaseMonth={"Jun"}>}count_LIVESLO_2)+sum({<CRCaseYear={"2016"}, CRCaseMonth={"Jun"}>}count_ELECSLO_2))
/(sum({<CRCaseYear={"2016"}, CRCaseMonth={"Jun"}>}count_LIVE2)+sum({<CRCaseYear={"2016"}, CRCaseMonth={"Jun"}>}count_ELEC2))
,'#,##0.0%')