# count

[#1]

Hi all,

I want to count the total of trucks used in my table.

Dimension = Week, performanceday

Expression = count(distinct(trucks))

now I like to only count monday -> friday so i was thinking about this:

count(DISTINCT{< Year = {$(=(max(Year)))}, PerformanceWeekday = {'mo'} + PerformanceWeekday ={'tu'} + PerformanceWeekday ={'we'} + PerformanceWeekday ={'th'} + PerformanceWeekday ={'fr'} >}trucks)

i'm pretty sure this won't work so whats the best solution?

kind regards

[manojkulkarni]

can you post you application ? Instead of putting so many set, it can be achieved by adding one flag for performance.

[MK_QSL · Accepted solution]

count(DISTINCT{< Year = {$(=(max(Year)))}, PerformanceWeekday = {'mo','tu','we','th','fr'} >}trucks)

[its_anandrjs]

Hi,

In place of this you have to load data from Monday to Friday and max year then it will show right data.

Thanks & Regards

[#5]

god how could I make such an error. thanks!

[senpradip007]

Hi

try like this:

count({< Year = {$(=(max(Year)))}, PerformanceWeekday = {"*"} - {'Sat','Sun'} >} DISTINCT trucks)

I assume that PerformanceWeekday holds the weekday name, eg- Sat,Sun,Mon, etc