Hi Christopher. Can you post an Excel file with a sample of your underlying data? The method to arrive at your answer depends on how your data is structured and how you have calculated % change.
Ok - have 2 questions here
the first is caclulating the % diff YOY and that is done with this
The second is counting customers <0
Baed on the Superstore example attached they return this
Note I just used Customer Name and filtered a small set
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
count cust names.twbx 1.2 MB
If this is the grain of your data (one row per store), then the simplest solution is two computed items:
[% Change]: [TY Sales] / [LY Sales] - 1
[Negative Change Stores]:
if [% Change] < 0 then
You can then drag [Negative Change Store] into the Viz, and it will count correctly whether you are looking at individual stores
Or across stores (Remove [Store Name] from Rows
If there is more than one row per store, you would need to use a different formula with COUNTD (to remove duplicates).
Negative Change Store.twbx 10.1 KB
This did it - thanks so much!
Great! Can you please mark the message as the correct answer, if appropriate?
Then it will appear as answered on the message boards, and help me build up my reputation.
Good luck with your work!