Divide 2 calculated fields in QuickSight derived from same column xyz

Question & Answer
, ,
1

Hi Team,

I am trying to divide 2 calculated fields in QuickSight derived from same column xyz.
i.e. fields1/fields2 but it fails without saying anything about error. My intention is to derive percentage from those 2 fields.

Note : I could have used countIf but seems it doesn’t support condition with empty string condition

Many Thanks!

2

Hi,

Could you provide us an example with dummy data and the calculations that are being done ? A screenshot of the error would also be helpful.

Regards,
Koushik

1 Like
3

@bipshik,

Can you please share the calculations used in field1 and field2. This should help us understand what the problem could be…

4

Hi @bipshik. We have not heard back from you regarding your question. We would still like to help. If this is no longer relevant after seven days, we will archive this question.

5

Hi Team, thanks for the response, i was able to figure out myself and we can close this. Division was problem as numerator and denominator were at different LAC

1 Like
6

@bipshik Glad you found the solution! Thanks for letting us know.

7

May I know what is the solution?

8

Hi @bipshik! Will you please share the solution?

9

@bipshik Can i know the solution please.

As here i want to take percentage of the values (current and 1-30) from the same column and want to add a calculated field for (current/1-30) . I want this calculation to show up as a row.

Please help

image

10

For this type of calculation usually you need to use LAC-W functions.

You need to use PRE_AGG in the numerator and PRE_FILTER in the denominator. It’s covered in this video. I put the timestamp for you.

Another more recent video about level aware calculations:

1 Like
11

Hi all,

Any one knows how to do a simple percentage based on the two LAC fields?
For example, I wanted to calculate the forth column/ fifth column, but QS won’t let me, because the different grouping keys. Anyone knows how to deal with it?

image
image707×757 69.9 KB

12

Hi @danddong I recommend that you re-post this as a new question so that it gets priority. (0 reply questions get prioritized above questions that already have a reply – and it looks like this is a new question.)

Hope this help! :slight_smile:

1 Like