All Activity

I am using version 12.0.8.27, so the following files cannot be opened. Is it possible to resolve this issue?

Hey David, this all makes sense. How would you subtract from dates in a configuration block? Or how would you use a calculated column in a configuration block? I have seen examples where these are static sorts of values provided by the user creating the automation job. Is there a way to provide dynamic values, outside of something like {"date"}, which uses the current date? I guess I am asking, is there any guidance document on what possible dynamic values and operations can be performed on configuration block parameters? Specifically those with dates?

Hi Naoki, Thank you for your inquiry. For implementing Spotfire Copilot, we recommend allocating the following resources for both the Data Loader and Orchestrator Docker images: Minimum Specifications: CPU: 2 cores Memory: 4 Gi This should provide a baseline for stable performance. Depending on the workload, increasing these resources may be necessary. If your client anticipates heavy usage, let us know, and we can provide more detailed recommendations based on specific use cases. Feel free to reach out if you need further information or clarification. Best regards, Marcelo Gallardo

Hi Iain, You may want to try something like this: <[Gate Desc] NEST Sum([Hours]) OVER ([Gate Desc])> That would nest your sum([Hours]) withing the hierarchy and calculates it per [Gate Desc]. Kind regards, David

Hi all, currently got a tree map to display booked hour data based on each area. i am using a custom expression within the hierarchy section to display the area name and also the Sum of hours within that section. the size of each entry within the tree map is also dependent on the sum of hours within each area. even though both hierarchy and size sections are both running the same custom expression "sum([Hours])", the size displays the hours within the section but the hierarchy custom expression displays hours of all the areas combined. how would i go about formatting this expression to also provide the name of the area and the associated sum of hours within that area? pic below of current hierarchy custom expression which is giving the result of name of area and all the areas hours combined

Thanks David, thats got it working now! thanks very much for your help

Hi Pamir, I would think you would nee a couple of calculated columns. You need to calculated the day number for previous Saturday as well as the day of sending. Both will result in a the day number. This number can then be used to calculate the days between the day of sending and the previous Saturday, to filter out how many days you need to 'go back in time' to filter. I don't have an example of the code, but maybe this gets you started. Kind regards, David

Hi Iain, I think I got it. I've created a simple data table, with 4 columns. I've added a dropdown list property, as per the below: Based upon the selection of the values of the drop down, a Filter column displays if it is true or not. The Filter column is the CASE statement. This is the view for the 1litre selection: Now, because I have altered your initial CASE statement, the view from the 1litre&2litre selection 'collects' both the 1litre and 2litre engines: And then you can tie the Filter column to your way of filtering out the data. The CASE statement I used to combine both 1litre and 2litre engines, is this one: case when DocumentProperty("EngineModel")="All" THEN [Engine Model]=[Engine Model] WHEN DocumentProperty("EngineModel")="1 litre" THEN [Engine Model]="1litre" WHEN DocumentProperty("EngineModel")="2 litre" THEN [Engine Model]="2litre" WHEN DocumentProperty("EngineModel")="Engine" THEN ([Engine Model]="1litre") or ([Engine Model]="2litre") ELSE [Engine Model]=DocumentProperty("EngineModel") END Kind regards, David

Thanks David, much appriciated!!

Thanks Iain, I'll try to see if we can make it to work. David

Hi Amit, I think the closest you'll be able to find information on this, is indeed the actionlog. I assume your interested in the time a web user has spend on an analysis file. This information is logged, but you need to do some calculations before you can see the time spend. The initial information is logged as per the below screenshot: The calculation you need to create, is between the logged_time or original_time of the lines load (or load_start) and close. The ARG columns, with the exception of ARG1 being AnalysisDxp, don't hold information that could help. One way to achieve this, is to create a new data table that has been pivoted (add transformation). When you pass ID2 and ARG2 as row identifiers, the Log_Action as columns and the original_time as value columns, you would end up with something like this. In this cross tab, you can then create a datediff calculation that calculates the difference between load_start time and close time: The calculation is as follows (duration being the one that does the subtraction of the load_start and close dates: UniqueConcatenate([load_start]) as [load_start], UniqueConcatenate([close]) as [close], UniqueConcatenate(DateDiff([close],[load_start])) as duration Kind regards, David

this is what I have got in the dropdown when the value "engine" is passed i use that within the visualization to try filter for the 1 and 2 litre from my previous screenshot this is my column structure, i am essentially wanting the 1 dropdown option that passes Engine to filter for the "1litre" and "2litre" only.

Hi Iain, So, the individual values (1litre and 2litre) should be taken into account whenever the dropdown is filtered to Engine (according to the CASE statement). Would it be possible to share some screenshots that include the dropdown values and the table values? Kind regards, David

Hi Black, Please find attached an analysis file that uses a slightly different approach as the other one. This one works better, as it flips the image layer properly. Kind regards, David Image layer toggle final.dxp

Hi David i have tried the concatenate as discussed and it is not giving any results, yes the values in the column are "1litre", "2Litre" and then individual items such as "200cc", "400cc"... therefore the dropdown i have got passed a value for "Engine", which i am then filtering in my visualizations shown in the picture attached previously ideally i the concatenate would work and the Engine selection in the dropdown would then pass the "Engine" document property filtering the visuals to only include entries with "1litre", "2litre". I'm assuming that concatenating this as concatenate("1litre","2litre") is then looking to filter for "1litre2litre" rather than "1litre" & "2litre" individually, thus no data is being filtered and the visuals blank at the moment. hope this provides a better explanation of my problem thanks iain

Hi Amit, If I'm not mistaken, the auth_login and auth_logout tables capture information for the session as whole. The actionlog table should hold the information about individual analysis files. But it's quite hard to make that connection indeed. Let me have a look at this request and see if I have can find anything you can work with/start from. I'll come back to you as soon as I have something useful. Kind regards, David

Hi Iain, What does your Document property holds as values (the values from the dropdown)? Are these: ALL, Engine and 'the other parts'? And what values does the [Engine Model] column hold? I assume 1litre and 2litre are different values. Is that correct? If so, I think the '&' between "1litre" & "2litre" will be the problem. You could try to concatenate them, into a single string: concatenate("1litre","2litre"). Kind regards, David

Hi @David Boot-Olazabal @Niklas Amberntsson - I have another question regarding the User Activity Log. I am trying to capture the time duration a dashboard has been accessed at the user level. I see 2 tables "AUTH_LOGIN" and "AUTH_LOGOUT" with the login and the logout information at the user level. I tried mapping the tables with the "ACTION_LOG" using the username field. However, this gives me the same login and logout information for all the dashboards accessed by a user. Thanks for your help.

@barchiel33 Thanks for the feedback! I did not publish the latest version! Pease try again.

Hi Community, I am working on an automation services job to open a dashboard, set a Date range filter within my data according to the current date, then send an email with the visualization. I am using the configuration block SetFilter statement where I would like to set the highValue parameter to a specific date, based on the current date (I am pulling weekly metrics, so I would like the highValue to be set to the most-recent Saturday based on the date of the automation services job being run). I see examples online where one can insert a field, such as {date}, but my use case is more for a calculated value, where the report should be sent on Monday (for example), but the filter should be set to show data through the previous Saturday. Would my solution have to utilize document properties with some sort of calculation? If so, how would I set up such a document property? Any help would be appreciated!

Hi @David Boot-Olazabal Thanks very much for the answer. I was worried as how the table with On-demand would behave when I put the dashboard on the Schedule Update.

Hi David i have a column called engine Model with "1litre", "2litre" and individual parts which i don't want to include, the dropdown works successfully and is passing a value correctly, but when i use the document property to filter my visualizations it does not filter correctly, this is my code, "ALL" works correctly, and also after else. the problem is implementing the middle part from the second WHEN to before ELSE

Hi Iain, For my understanding, you're trying to combine the option 1 and option 2 values, when the dropdown list is filtered to option 3? And you're struggling to get the combination of option 1 and option 2 into the fixed values of the dropdown list. Is that correct? If so, do you get an error message (you can't save the dropdown list property? Or does it display the value erroneously? Could you share perhaps your dxp file or some screenshots that makes your use case more clear? Because I can't figure out if you just need a concatenate function in the CASE statement (instead of "option 1"&"option2") or that you would need a different approach. Kind regards, David

I am currently making Spotfire where I am filtering my data using a dropdown list with fixed values, the fixed values are currently "All", "Option 1", "Option 2" and the one I am struggling to syntax correctly when filtering my data is option 3 which is "Option 1 & Option 2" where i am i going wrong? code below bold is the section i am struggling to syntax correctly And case when DocumentProperty("Model") = "ALL" THEN [Model]=[Model] WHEN DocumentProperty("Model") = "option 3" THEN [Model]= "option1" &"option2" ELSE [Model]= DocumentProperty("Model")END

Hi Amit, If you want to know if it is possible to schedule an update for an analysis file that has also on demand tables, the answer is yes. When scheduling an analysis file, all 'normal' tables will be refreshed at the time of running. On demand data tables will not be refreshed, since they will only 'act' whenever they are called upon, as Olivier pointed out. I have done this many times at customer projects and also in my own test environments. You can just start scheduling your analysis file via the administration console and let it run in the server. When you then open your analysis file, you will see that the data is loaded from the cache, for all tables except the on-demand ones. The latter will only load data, when they're getting triggered. Kind regards, David