Comparative Sales

[dspringer]

Please use this starter dashboard to explain your answer if you can help!

Comparative Sales

I’m looking to create a side by side table view of a single customer sales vs another customer’s sales as well as the % difference between the two. I want these customers to be selected by the end user. I’m not sure how to approach this when the number of records within a certain dimension exceeds what is reasonable to add to a calculated field. Is there another way to do this?

[ErikG]

Hi @dspringer
you could create a workaround, if you only want to compare 2 customers.
ComparativeSales
BR

[dspringer]

@ErikG thank you but this doesn’t meet the requirements as I’m looking for the dashboard user not the developer to define which customers are compared.

[Giridhar.Prabhu]

Hi @dspringer

See if this is similar to your requirement.

Question about difference calculation in pivot table

Hi, I have a Analysis as such: [Pasted Graphic 32 copy] With the same aggregation/dimensions showing in table, is there any way I can calculate difference between A-B, A-C, A-D and so forth? From difference - Amazon QuickSight it says this function only works for the difference between measures based on one set of partitions and sorts. Therefore, if index is -1, right now I can only achieve A-B, B-C, C-D and so forth. Thank you for any help!

[Brett]

Hi @dspringer,
It’s been awhile since we last heard from you, did you have any additional questions regarding your case or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[dspringer]

@Brett I was not able to find a work around and the suggested solutions didn’t meet the requirements.

[Brett]

Hi @dspringer,
Take a look at the Arena example that I put together, let me know if this is more similar to what you are trying to achieve:

Comparitive Sales

[Giridhar.Prabhu]

Can you check if this works for you
Forecast by Hour

[dspringer]

@Brett this is effectively what I was looking to do but is there a way to toggle dimensions?

[Brett]

Hi @dspringer,
What dimension(s) are you trying to toggle?

[dspringer]

@Brett any would work but how about product? So effectively customer 1 and 2 would become product 1 and two but there needs to be a way to switch back and forth easily.

[Brett]

Hi @dspringer,
You could try building another parameter that chooses ‘customer’ or ‘product’. Then setup the customer and product controls (dropdowns) to only show based on the new parameter’s selection (this would need to be completed in free-form).
You won’t be able to handle the controls to hold information for both dimension values, which is why you’d need to setup 2 controls for product as well and then toggle them to show based on your customer or product parameter.

Let me know if you have any additional questions!