Show current week data in straight table

[praveenkumar_s]

Hi gurus,

I have created straight table with the following data.By default, I need to show current week data only in straight table if user select any date value it will show the data for respective date in the straight table. Is there any other way to achieve it?.

please find the screenshot for your reference.

[sunny_talwar]

Do you mean Current Day or Current Week? May be this

If(GetSelectedCount(Timestamp) = 0, Sum({<Timestamp = {"$(=Date(Today(), 'M/D/YYYY'))"}>}Measure), Sum(Measure))

[dapostolopoylos · Accepted solution]

If i get straight, all you have to do is create a straight table with Metercode as Dimension an Max(Timestamp) as Expression...

You may have to use MaxString(Timestamp) alternatively depending on the data type of the Timestamp column...

[praveenkumar_s]

Hi,

Its current day.

Where i need to use this expression. in dimension or Expression in straight table?

[rubenmarin]

Hi praveen, maybe with set analysis using max(dateselected) as reference:

Only({<Timestamp={">=$(=WeekStart(max(dateselected)))<=$(=WeekEnd(max(dateselected)))"}>} Timestamp)

[sunny_talwar]

Expression

[praveenkumar_s]

yes. exactly what i want. thank you very much.

[dapostolopoylos]

I'm glad i was able to help...