2 Replies Latest reply on Sep 19, 2018 9:32 PM by Mahfooj Khan

# Calculating specific data within field

Hi,

I would like to ask some questions regarding to calculating of field function.

I have a set of vehicle datas, model (a,b,c,d,e) that consist of different mode(0,2,4,8) that runs on different days in different month

So the context is that every car will definitely runs mode 0.

Only some of the vehicle will use mode 2 (which will definitely run mode 0 in between somehow)

So if i were to have a graph, there will be 5 vehicle running in mode 0, of which, 3 vehicle will also be running in mode 2. The graph will then show me that mode 0 consist of 5 car and mode 2 consist of 3 car.

I would like to ask if there is any ways for me to calculate the difference to get the number of cars running purely on mode 0?

Due to confidential materials, i am not able to upload any thing.

The vehicle data are in string and the mode is in numbers.

Hello,

• ###### 2. Re: Calculating specific data within field

Hi,

You don't need to share your confidential data though you can create some dummy data which has same data structure like your original source.

However, you can try this,

Create a calculated field using below LOD{} expression, it'll return distinct counts of model per mode.

{FIXED [Mode]:COUNTD([Model])}

Now, drag your date field in columns shelf and above calculated field in rows and check.

Let us know if this help.

Mahfooj