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?

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.

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)?

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!

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?

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!

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.,