klipfolio
How to make an aggregated line chart in klipfolio
Trying to make an aggregated line chart based on some signups, but the issue is that the dataset I have (json), only gives me a value for each day, and not the aggregated (a number that increments each day).
Does anyone have an idea what function or setting i need to use?
Solution
Are you referring to accumulating and aggregating the daily values? IE. the value for yesterday = 1 and the value for today = 2 so the value of today in the series is 3?
If so, you can use the CUMULATIVE() function in your series:
CUMULATIVE(@/number)
This will cumulatively add your daily data in your JSON data source from the first record to the last.
- How can I close over variables in kdb/Q?
- When is the EACH operator extension necessary in K besides mod/rotate?
- Handling single-character strings - in a function or in its caller? ssr()
- Kdb+ data fomat when writing to a file
- How to convert a symbol to a string in kdb+?
- Sum of each two elements using vector functions
- A dictionary with a single value and multiple keys
- Table transformation, table as list of dicts
- Accumulator gives different result then direct function applying
- Reshape [cols;table]
- FK field over IPC
- Protected execution, 2 cases
- Enums for tables
- Converge (fixed point) syntax difference in q and k
- .Q.trp and bt handling
- NULLs in q and in k.h
- Strange view declaration behaviour
- How to build a parse-tree of projections?
- Could not evaluate manually created equial ~ parse tree
- Select distinct for all columns from keyed table
- Parallel execution: blocking receive, deferred synchronous
- Multiple variable assignment in q
- Select a table from the inside of external select
- Select when one of filter-column may not exists
- What is the meaning of `s attribute on a table?
- On parallel execution - which side reports about an error?
- Validate if a keyed table have unique keys
- Applying dictionary to dictionary
- About xkey implementation
- Parse tree built on values from vars