Date Format

[Anil_Babu_Samineni]

Hello,

I have the format MM/DD/YYYY HH:MM:SS and i am trying to MM/DD/YYYY

I don't know why this is showing.

I tried like below

date(date#(First_StartTime,'MM/DD/YYYY HH:MM:SS'),'MM/DD/YYYY')

[Anil_Babu_Samineni]

Yes, Thanks Sunny. 10 also need to show different like blue then yellow? I am about to finish this

[sunny_talwar · Accepted solution]

Try this:

=If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime)), LightRed(),

If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime), 2), Green(),

If([Dashboard Running] = Max(TOTAL Aggr(Count(DISTINCT Dashboard), First_StartTime), 3), Blue(), Yellow())))

[Anil_Babu_Samineni]

interesting, Thanks.

[Anil_Babu_Samineni]

Sunny, I have one more doubt.

Can you please have a look which i attached below.

Here, what i want to achieve is From sheet3 I have values for 19/07/2016 are 102

But, While i am trying Sheet2 Bar graph Why this is showing 128 for 19/07/2016. Can you please suggest me?

[sunny_talwar]

Because the Sheet3 expression seems to be distinct values per dimension. To get 102 on the chart, try this:

=Sum(Aggr([count of select], Dashboard))

or

=Sum(Aggr(Only([count of select]), Dashboard))

or

=Sum(Aggr(Avg([count of select]), Dashboard))

or

=Sum(Aggr(Sum(DISTINCT [count of select]), Dashboard))

[Anil_Babu_Samineni]

Yes, here why not showing values by date wise. And, I've tried that. Unfortunately, the dates are not showing good way. How to figure it out.

[sunny_talwar]

Looking to get this?

Expression:

=Sum(Aggr([count of select], Dashboard, TaskRunDates))

[Anil_Babu_Samineni]

Thanks for your time.

[sunny_talwar]

No problem at all Anil. I just recommend to start a new thread with new requirement in the future.

Thanks,

Sunny