Make a New Field

[rmdnkevin]

Hi, everyone.

I have a field in main table like this :

The problem is, can I make a new field that contain a value from it ? For instance, I need field CountofSubmittedData, and the value will be the count of Submitted Data from the main table.

Thank you everyone

- Kevin

[MindaugasBacius]

This may do the job:

Left Join (MasterTable)

Load Status

    ,Count(Status) as StatusCount

resident tmp

Group by Status

;

Why do you avoid Count function in Chart type table?

[nishanthi_8]

You could use count(status). But what exactly is your need ? You need at script or chart level ?

[rmdnkevin]

I already use count function for making chart of it, but I need its value in a field, just like this :

[naddasandeep]

Hi

You can use aggr function for the same like

load the table and aggr(count(status),status) as Counted data in the script

[nishanthi_8 · Accepted solution]

Then you could simply use count(status)  and group it by the fields in the table

[rmdnkevin]

Thank you so much for the answer, it helps

[rmdnkevin]

Thank you so much for your response