Post reply

Showing only line graph till today's date.

  • May 21, 2012 at 4:00 am

    #261237

    I have a requirement where in i want to show the commulative sum till only this month

    I have created cummulative sum using runningvalues in expressions.Now I dont want to show the graph for next month i.e after may as we dont have completions for those months yet. Any help please?

  • May 21, 2012 at 7:17 am

    #1490399

    Constrain your dataset not to show the next month. If you can't do that, then put a filter the graph.

  • May 21, 2012 at 8:10 am

    #1490436

    I have a dataset for monthly view for forecast and completed for whole month Jan to Dec

    but cummulative graph for complete I need to show only till this month. so adding filter will limit the view for all the graphs till this month ( i.e monthly comp forecast and comm com and forecast )

    Any help is appreciated.

  • May 21, 2012 at 12:46 pm

    #1490620

    vinay4444 (5/21/2012)

    I have a dataset for monthly view for forecast and completed for whole month Jan to Dec

    but cummulative graph for complete I need to show only till this month. so adding filter will limit the view for all the graphs till this month ( i.e monthly comp forecast and comm com and forecast )

    Any help is appreciated.

    Change the expression of the completed cumulative to check the current date. If its in the future then return NULL.

    =iif(fields!mydate.Value>now(), NULL, fields!cumulative.Value)

    Null values do not show rather than forcing 0.

    Fitz

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply