Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Then you could simply use count(status) and group it by the fields in the table
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?
You could use count(status). But what exactly is your need ? You need at script or chart level ?
I already use count function for making chart of it, but I need its value in a field, just like this :
Hi
You can use aggr function for the same like
load the table and aggr(count(status),status) as Counted data in the script
Then you could simply use count(status) and group it by the fields in the table
Thank you so much for the answer, it helps
Thank you so much for your response