0

Aggreggate like Excel does

Hi , i have a table with multiple headers , one of them being "Month". Usually in excel i would filter it (the month i need) and apply aggregate to the column that has the numbers that needs summed. Is there any formulae that can achieve the same thing in ninox? for example if i filter "January" i can see in the small view the aggregated sum for the entire rows visible, but i can`t use that number to make operations with it. I have a lot of drivers that need to meet a certain number of working days every month and each entry is counted as 1 day. When i filter "january" i would like to detract from my standard the counted days to see who had more or less than the standard and whatever i tried just returns the sum of all days of all drivers and not the counted days for each driver as it is when i have the driver field grouped after. Sorry if this doesnt make sense , english isn`t my first language.

2 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Hi Roxana -

    This sounds like a good place for a dashboard. Check out this youtube video from Nioxus for a good primer on dashboards. For me, once I learned dashboards, I rarely touch my raw data tables and get all my information from my dashboards.

    If you want to use your table view then it will be helpful to get some info about which table you are working in and the field and links you are trying to get data from.

    • Sider Fier
    • Roxana_Alexe
    • 2 yrs ago
    • Reported - view

    Hi Fred, thanks a lot for both reply and solution. I will take a closer look at this as it seem its the answer i was looking for. 

Login to reply

Content aside

  • 2 yrs agoLast active
  • 2Replies
  • 77Views
  • 2 Following