Custom aggregated fields as dimesions

Q&A
,
1

Hi, I’m trying to use a HeatMap to show a cross-ABC analysis.
I’d like to use a HeatMap to show the number of items that have class A for stocks, class A for sales, class A for stocks and class B for sales and so on.
The result should be something like this:

                                          Sales
Stocks                       A               B                   C
A                         1578             785                 145
B                          345            2587                 647
C                         9785             655                3781

I would also like to show in a separate table the list of items that are connected to each cell of the HeatMap when I click on the cell.

I calculated ABC classes for stocks and sales through custom calculated fields in my analysis.
Everything works fine, ABC classes are correctly calculated. But when I try to use these fields as dimensions in the HeatMap, I get the message: “Custom aggregation field is not allowed as a dimension”.

So, I tried to create these calculated fields for ABC classes in the dataset.
Everything works fine, ABC classes are correctly calculated and I can find these fields in my dataset.
But when I try to use the fields in the HeatMap, I still get the message: “Custom aggregation field is not allowed as a dimension”.
This means that calculated fields can never be used in HeatMap as dimesions, regardless where they have been declared.

Is there a way to get what I’d like to?
Thanks for your help.

2

Hello @LUCA1 , welcome to the Quick Sight community!

You could try creating the calculations in CustomSQL when you ingest the dataset from your data source.

You could also try creating the heatmap using HighCharts instead of the Quick Sight native visual.

3

Thanks Duncan, I’m new to highcharts so I will have a try.

4

Hi @LUCA1

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

5

Hi @LUCA1

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!

Custom aggregated fields as dimensions