displaying the max date available from the data

[Anonymous]

I need to display the maximum date from the spreadsheet at any given point in time and the sum of the mins for that month for a particular service id

Dimensions to be max(PERIOD_NAME) and SRV_ID while the expression is simple sum(CUSTOMER_IMPACT_MINS).

but max(PERIOD_NAME) shows an error for calculated dimension.

not sure what is going wrong as when i put this in a text box it works fine but shows error when i put it in a chart

Sample data attached.

[girirajsinh]

What are your chart expression and dimensions?

[Anonymous]

Expression is sum(CUSTOMER_IMPACT_MINS).

Dimensions need to be SRV_Id and max(PEriod Name)

[girirajsinh]

try expression

sum({<PERIOD_NAME={"=max(PERIOD_NAME)"} >} CUSTOMER_IMPACT_MINS)

[Anil_Babu_Samineni]

You may try

sum({<[PEriod Name] = {''$(=Max([PEriod Name]))"}>}CUSTOMER_IMPACT_MINS)

Updated, Tested

Sum({<PERIOD_NAME = {'$(=Max(PERIOD_NAME))'}>}CUSTOMER_IMPACT_MINS)

[#6]

Create a variable for max period using date#. then try:

sum({<PERIOD_NAME={"=$(vEndField)"} >} CUSTOMER_IMPACT_MINS)

Good Luck,

Pravesh

[girirajsinh]

Yes as Anil Babu spotted out, I missd the expansion $ here. But this gives your always last period, as you always have periods  till Dec. So if you intend to show max across the period and wann a show that period, use Max in expression and may be period in dimension. and Uncheck "show zero values" from presentation tab, in case wannn a show all SRV_ID

sum({<PERIOD_NAME={"$(=MAX(PERIOD_NAME))"}>} CUSTOMER_IMPACT_MINS)