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?

[krishnacbe]

add year and month operators in your expression to get this.

share the expression you used for SLA calculation, will try to help you to build for current month

[#3]

Here is the SLA Calculation:

=num((sum(count_LIVESLO_2)+sum(count_ELECSLO_2))/(sum(count_LIVE2)+sum(count_ELEC2)),'#,##0.0%')

[krishnacbe]

Please use below expression.

Date is your Date column. you can replace the hard coded values with variables too for getting the current year and month

=num((sum({year(Date)={'2016'},month(Date)={'Jun'}}count_LIVESLO_2)+sum(({year(Date)={'2016'},month(Date)={'Jun'}}count_ELECSLO_2))/(sum(({year(Date)={'2016'},month(Date)={'Jun'}}count_LIVE2)+sum(({year(Date)={'2016'},month(Date)={'Jun'}}count_ELEC2)),'#,##0.0%')

[#5]

Excellent!  What if I want to always show the most current month?

[krishnacbe]

You need to create a variable as below

vLatestMonth=max({<Year={$(vLatestYear)}>} Month(Date))

[#7]

Sorry, but this doesn't seem to be working...I am running into errors when I get to 'month' where it doesn't recognize it:

=num((sum({year(ROW_ADDED_DTTM)={'2016'},month(ROW_ADDED_DTTM)={'Jun'}}count_LIVESLO_2)+sum(({year(ROW_ADDED_DTTM)={'2016'},month(ROW_ADDED_DTTM)={'Jun'}}count_ELECSLO_2))/(sum(({year(ROW_ADDED_DTTM)={'2016'},month(ROW_ADDED_DTTM)={'Jun'}}count_LIVE2)+sum(({year(ROW_ADDED_DTTM)={'2016'},month(ROW_ADDED_DTTM)={'Jun'}}count_ELEC2)),'#,##0.0%')

[krishnacbe]

Try to put this expression in one text box month(ROW_ADDED_DTTM). if it is giving as integer then you need to compare the integer value.

[#9]

That's interesting, there is no result when I do this, even though it is defined as a date in my script.

[krishnacbe]

Sorry Please give that expression in List box to view the values.

Or select a date in field ROW_ADDED_DTTM. then text box will display the data.