carthur Member

@ColemenWilson I was referring to Custom Attribute that we are using and i thought they all came together. I didn't think they had to be turned separately.

@ST_-Superman-_ So for example we may have a client called AXIS. They order from us a pencil as one of their products. We manufacture some part of the pencil in our plant and order the erazer or rubber from another company. In our data, we will have the cost of ordering the erazer from another company and the cost to us…

@ColemenWilson @GrantSmith @marcel_luthi Thanks for looking at this for me. I would like to visualize the data like the table below. I want to see their amounts under conversion and amounts for the same customer under FO and therefore writing the beast mode calc, I should be able to split the amounts in order to put them…

@ColemenWilson I am a little confused on your logic here - to use the policy1, 2 and so on, wouldn't policy1, 2 and on has to be datapoints in the dataset? Or say i want to use the policy 1, may be add a constant value for policy 1? I am a little confused here

@marcel_luthi Yes when I remove the PDP they see the data and therefore it is clearly something with the BETA function. Contacted DOMO and it has been raised now to the Level 3 at developers' level just FYI. @Ashleigh Resharing the datasets, to people in the group and also individually still didn't solve it either.…

@swagner Did you take your video down?

Well, I am guessing you wish to hard code using the IN function because I set up one list that I was able to select multiple for example locations which acts as the IN function.

@Ashleigh Thanks for your suggestion, I will reshare the datasets and see. But do you mean sharing individual ETL datasets feeding the dashboard with the group or each member individually in the group? Many thanks

@marcel_luthi Thanks for looking into this for me. Below is a screenshot of the PDP rule. Also, your guess on where the rule was applied, I don't think I applied it to the ORIGINAL datasets. I applied them to the final datasets ETL as that is what is been fed unto the created dashboard. Does that make a difference? And…

I believe this could be achieved by choosing the data type list version if I understood what you are asking for. When setting up your attribute, there is an option to select for example datatype STRING or STRING LIST. The string list would allow adding multiple attributes just as the IN function does.

Thank you both. @GrantSmith your second option didn't work but very interesting calculation, would you please explain that concept a little for me?

@MarkSnodgrass Thanks for the reply but if I only allow the revenue case statement to return only the revenue amount, I wil have to use the in built formating to make it show as currency. If that is the case when I toggle to use the other variable which is NOT currency it still shows as currency. How would I be able to…

@GrantSmith amazing. thanks for the explanation. would you say the below code will be the best for previous year mtd or there's simpler way of writing it?

@GrantSmith Could you please explain the beast mode using the last-day concept on how that will filter for MTD and potentially for previous years please MTD

@GrantSmith Thanks for the reply. There are no other date fields and yes I was applying the order type filters on the raw data.

@pauljames That would be very interesting. I have attached a pic of the ETL

@MichelleH Yes I just checked on the only filter which is just a selection of specific categories to show on the card and yes when I removed it, the date range updated correctly. However, that still shouldn't be the case as these categories have invoices as current as today so the date range should still be updating. With…

Thank you very much but seem to not have brought all the data

Thank you soo much

@MichelleH thanks but I forgot to add the concept on my previous reply.

@MichelleH Thank for the reply. That example was just something quickly put together. I am working with a more complicated equation which involves nested case statements and varaible selections. would that same concept apply? The actual idea I am working on, but I get that granularity issue.

Thanks @trafalger for the response. The beast mode calculation you gave above logically makes sense however, it pulls the same amounts for the current year figures. what could be going on here?

Amazing that would super helpful. Thak you all

omg! really? - you are awesome. But it does just populate the actual logics not the names for the first and second CF's? Its a little untidy to understand complicated logics - I hope they can clean this up sometime. Thank so much