Use this tag for questions related to the WebDataRocks Pivot Table library.
Questions tagged [webdatarocks]
79 questions
1
vote
1 answer
How to get column total on webdatarocks using getData?
I tried recommendations given here.. but I still couldn't get specific column total details. e.g. v0. May I please request you to share details on how to extract specific column & row details in webdatarocks pivot without a cell selection.
I also…
learner
- 29
- 4
1
vote
1 answer
How to avoid Webdatarocks filter function to avoid linking filter in charts and Pivot table
[1] I have a webpage having Webdatarocks Pivot table and Highcharts(integrated with webdatarocks).
I have a requirement where I need to show chart with some filtered data, so I am using getdata() function of WebDataRocks, which act as datasource…
madhubala
- 45
- 6
1
vote
1 answer
How to get same numerator value on dividing by zero in Webdatarocks table
I want to get same numerator value when Denominator is zero in Webdatrocks table.
In documentation they have mentioned function "divideByZeroValue", but it can hold only static value.
https://www.webdatarocks.com/doc/number-formatting/
Please assist…
Jeery sum code
- 118
- 12
1
vote
1 answer
Is it possible to show fields in sub object (tree based) from JSON file
I want to show the fields from JSON objects. Currently, all the fields are loading only from 1st level of the object. Example JSON file is given below.
"DATE": "2021/01/02",
"VOUCHERNUMBER": "GST/20-21/3833",
"VOUCHERTYPENAME": "Udaan…
Ashok Kumar
- 11
- 1
1
vote
1 answer
How to add non-aggregated columns in WebDataRocks
Some content in the data is detailed information. For functional needs, I need it to be displayed in the report, but it should not be used for aggregation, but displayed in each item. As shown in the picture, the column (name, version) should be…
lyt
- 11
- 1
1
vote
1 answer
How to set static column in webdatarocks?
Can I create a static column in webdatarocks?
for example, I have data like this. (please see in the picture)
there is no data for "3. Mod" Jobcategory in 2. Dies Face, but I want to set all jobcategory for every linecategory, although no data.
Maulana Abdurrahman
- 11
- 1
1
vote
1 answer
Add custom formula to webdatarocks
Is it possible with webdatarocks to calculate % of difference per row for each period?
I want to add 3rd column and get % od difference for "Sum of foodDonorDelta" so for 30/09/2020 it will be null, for 31/10/2020 it will be 4000%, for 30/11/2020 it…
breq
- 24,412
- 26
- 65
- 106
1
vote
3 answers
azure-devops extensions do not accept SVG files
I am using a pivot table tool (webdatarocks) in an azure DevOps extension project. The tool icons in an SVG file, but azure DevOps extensions projects do not accept SVG file types and gives the following error in the publishing stage.
Error…
husnu
- 354
- 3
- 15
1
vote
1 answer
How to apply conditional formatting to pivot table dynamically
I would like to set conditional formatting in webdatarocks like this:
"conditions": [
{
"formula": "AND(#value > 5000, #value < 8000)",
"format": {
"backgroundColor": "#3cff00",
…
AlexV
- 11
- 1
1
vote
1 answer
Django: how to format time (hh:mm:ss) when display in JSON?
I save time in a models name Heures and display it using WebDataRocks library that accept JSON
Doing that, data are display with this format: 08:20:34.234617
How could I display it 08:20:34?
views.py
def index(request):
data =…
SLATER
- 613
- 9
- 31
1
vote
2 answers
JSON - Django/Webdatarocks: unable to correctly serialize data in JSON
I currently develop a Django project and try to implement WebDataRocks
WebDataRocks is a free web reporting tool for data analysis and visualization
I works but my problem deal with correctly presenting data to be updated in Webdatarocks
I would…
SLATER
- 613
- 9
- 31
1
vote
2 answers
import a library into a single file component of vue.js
I need to import a library in my vue component, in the documentation I explain how to install it using npm (already do this step) but not how to import it into a vue component, this is the way in which it explains how to use the files:
FeRcHo
- 1,119
- 5
- 14
- 27
0
votes
1 answer
Problem in rounding values in a web data rock pivot table
Yesterday we noticed that several values in our web data rock pivot table were not rounded to the second digit as specified by the Format cells settings. The digits after the decimal point were much more.
Could this be some kind of bug or was it a…
Ra Di
- 1
- 2
0
votes
1 answer
Uncaught TypeError: Cannot read properties of undefined (reading 'aj'): Error coming when am using WebDataRocks Pivot Table
enter image description hereI was trying to use WebDataRocks Pivot Table for one of my Projects. I am using the basic code I copied from their documentation but it is giving this error: Uncaught TypeError: Cannot read properties of undefined…
iknownothing
- 1
- 1
0
votes
1 answer
WebDataRocks Highcharts not updating data when filtered
When filtering on a parent row in the slice; the child row (which is set as the row slice on the chart) is not updating. The chart does not change. Below is the JavaScript code.
If you filter the pivot table on country, the chart does not change…
Dean Braun
- 1
- 1