Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm looking for some help getting a bar chart working where each bar represents the percentage of all customers using a given product.
The original data table has one row per unique customer, and there is a column representing each product, with a cell value of 1 if the customer using that product, and 0 if not.
I've gotten the bar chart working by using an AVG per product, but then the bars are not clickable - I'd like the data table next to the bar chart to update with the subset of customers using the product for which bar I click on in the bar chart.
Any ways to make this work (with or without changing the format of the source data table)?
Thank you.
Hi @darrenhe
You need your table (with one column per product) to another with a column called (in example) ProductName and another with that 1 and 0's values. You can do this usin crosstable
MynewModel:
Crosstable (ProductName,Value10)
LOAD
customer,
MyProcuct1,
MyProduct2,
MyProduct3,...
FROM TABLE;
After that yoy can use productname as a dimension (and you'll be able to select as you suggested). Your expresion for percentage should looks something like that
sum(Value10 ) / coun(total disticnt customer)
Hope it helps
Regards