Products

[pkz]

Hi,

Thanks for the chart-width suggestion.

Regarding the allowRowgroup for grid, how can I specify only certain rows to be allowed to be grouped?

[pkz]

Hi,

I see this error:

I have shared this question as part of my email support request. I hope you can take a look at it.

[pkz]

Can’t edit previous post, but more issues:

 

Code: https://codepen.io/ttwer2/pen/ZEjxBzp

 

1.

when switching between pivot and grid

ex: switch to pivot – so some charting, switch back to grid results in empty grid with the following error:

Grid: Invalid property name "allowRowGroup" set for Column: "col8"

Uncaught Grid: Invalid property name "allowRowGroup" set for Column: "col8"

2. charts are cut off I need to scroll to see the other parts of the chart

 

3. everything in pivot is VERY laggy with only 10k rows of data (randomly generated – also part of the code)

 

 

 

• This reply was modified 1 year, 10 months ago by pkz.

[pkz]

Sorry for the double post – minor problem: in your most recent code, the chart options for normal grid does not work – selection or just clicking it.

I comes up with a blank chart.

I have to use grid.createChart('bar'); if it’s not a pivot to chart things properly for a grid – is this an issue?

Also, even with using grid.createChart('bar');, I’m not able to select and plot for datasets that have 100+ columns and many rows. I don’t see any errors in the console also.

Any tips?

 

EDIT: here is the large sample where I’m not able to get the charting for normal grid to work with your code: https://codepen.io/ttwer2/pen/ZEjxBzp

• This reply was modified 1 year, 10 months ago by pkz.

[pkz]

Solved by defining specific height in css for table element.

If there are better/other solutions, please share if not, please close this topic.

Thank you

[pkz]

Thanks! That solves all my questions for now!

[pkz]

Hi,

 

I understand the parameters of the smartChart object/class but what I wanted to know was if it was possible to dynamically assign the type. Here is an example of what I would like to do:

 

function process_selection(chart_type){

// assume this function gets the grid’s selection and processes the data so that it can be used for charting – i.e the code inside the chart’s onclick in your codepen.

//how can I use the chart_type variable here to change the properties of the already defined window.Smart("#pivot-chart",...) ? (since this is what we are using to draw on)

//the obvious solution is to re-define the entire smart object with the new chart type – but this seems suboptimal – am I understanding the concept of smart objects correctly?

}

With this function, I can assign to onClick on different chart types:

process_selection('line')

process_selection('bar')

etc.,

[pkz]

Hi,

 

Thank you again for the help! Everything is perfect now!

One small question: Is it possible to change the pivot-chart type dynamically?

 

window.Smart(
"#pivot-chart",
class {
get properties() {
return {
caption: "",
description: "",
xAxis: {
dataField: "country",
gridLines: {
visible: false
},
type: "basic"
},
colorScheme: "scheme28",
seriesGroups: [
{
type: "column",
columnsGapPercent: 50,
seriesGapPercent: 0,
valueAxis: {
description: "Revenue",
axisSize: "auto"
},
series: []
}
]
};
}
}
);

This is used in the pivot group charting. What if I wanted to dynamically have buttons like line, bar, chart etc.? does it involve changing the data again? or is there a way to pass a parameter to the smart-chart

i.e: document.querySelector("smart-chart").dataSource = chartDataSource; so that we can easily switch from line or bar?

 

Thanks again for all your help! Really liking using the library so far!

 

 

[pkz]

Hi,

Thank you for the update. The fix seems to be partial has different ways of selection have different results and I’m still seeing the empty labels sometimes – it appears only when the chart moves. Is there any way to “redraw” or “refresh” the chart?

In this video, I’ve shown 2 issues:

1. The labels not appearing unless I move the chart box
2. The chart not displaying data when the _same_ selection is made slightly differently (same data, but different ways of selection)

Video: https://jmp.sh/NW90Ealy

Can you please help with this?

[pkz]

Hi,

Thank you for the code!

The custom function modification is not exactly what I imagined it to be, but I will inspect the source since I just purchased the license.

Regarding the charting, I’m still seeing a lot lesser occurrences of the chart with no labels. Can you please let me know what change you made or what causes this issue? I saw the code and the logic change seems to be related to multi-bar charting/data management.

Regarding the multi bar, is it possible to chart this:

If I chart this, it comes up with an empty chart.

 

Thank you for your help!

 

[pkz]

Hi,

Thank you for your response and help!

1. No problem
2. I don’t understand your solution here. What I would like to see is, for example, a multiplier of x2 for every number of Income. Say, I define a function foo(x){x*2} and apply it to all the column’s values, and I foo to be a list of summary types like sum, stddev etc., – is this possible? so basically my own summary functions
3. Got it – thanks for indicating this!
4. Thank you! This would definitely be a HUGE addition!
5. This is great progress. I just have a few questions regarding this:
   1. When the chart is generated, I often see empty axis values:|
      
      But this clears up on clicking on the legend again – is there a way to make sure they are always displayed correctly?
   2. I noticed that in your example you have used income as an example, what if I want to support other chart types with say, multiple datasets, how can I easily change the chart type of smart-chart (i.e #pivot-chart)?

 

 

[pkz]

Great! Thank you – that fixed it!

Updated working code: https://codepen.io/ttwer2/pen/ZEjxBzp

Few questions for pivot:

1. Is it possible to add multiple summaries of the same column? for example, sum(expenses) as one statistic and avg(expenses) as another?
2. Are we able to define custom stats/calculations for the summary?
3. I’m not able to use the conditional formatting mode in the above code – am I missing something? i.e nothing happens when I click the button on the top right corner
4. In pivot mode > filters, I’m only able to see the numbers as categorical values where I can select or de-select them. How can this be changed to behave as per the type of column? i.e if number -> then range or if text, then string matching
5. How can I sort the columns in the pivot? for example, the stdevp(income) and the group in the pic below [Solved]
6. Is it possible (programmatically) to plot the selection in a pivot via charting capabilities of htmlelements? example:
   this would come up in a chart with X-axis showing USA,AUS,UK and y-axis showing stddevp(income)
   this would be an excellent feature and I’d be grateful and go for the license if you can help with this! 🙂

Thank you!

• This reply was modified 1 year, 10 months ago by pkz.

[pkz]

Hi,

 

Thank you for the response! That was helpful!

I’m not able to convert a grid to pivot.

Here is the code: https://codepen.io/ttwer2/pen/ZEjxBzp

 

I followed the example of converting a table to pivot, but I think I may be missing something. Can you please help?

[pkz]

It’s a safe website – no sign up required for video upload. how can I share videos with you? there is no options for in the forums…

https://drive.google.com/file/d/1xC2Ch-Vi8SH9u4Ucnwbj0tkt-fIZYrte/view?usp=sharing

• This reply was modified 2 years, 8 months ago by pkz.

[pkz]

Thank you for the answers again, Peter.

You still have not addressed the last bug report I mentioned which is the page jumps when clicking on sort/filter (video attached in previous post).

Regarding Q1. I’m sorry I meant columns – not rows. Hiding columns based on priority level as the windowsize gets smaller – is this possible?

[Author]

Posts